با سلام


using BookKeeper.Books;
using BookKeeper.Lend;
using BookKeeper.Member;
using DataLayer.Context;
using DataLayer.SeedData;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Tools.Convertor;
using Tools.CustomType;
namespace BookKeeper
{
public partial class frmMain : Form
{
public frmMain()
{
InitializeComponent();
}
private void frmMain_Load(object sender, EventArgs e)
{
this.Hide();
frmLogin frmLogin = new frmLogin();
var result = frmLogin.ShowDialog();
if (result == DialogResult.OK)
{
this.Show();
}
else
{
Application.Exit();
}
txtDateTimeNow.Text = $"امروز {DateTime.Now.ToShamsi()}";
txtTime.Text = DateTime.Now.ToLongTimeString();
BookKeeperSeedData.SeedData();
BindDashboardData();
bindGrid();
}
void bindGrid(string search = "")
{
using (BookKeeper_DB_Context ctx = new())
{
dgvLendBooks.AutoGenerateColumns = false;
dgvLendBooks.DataSource = ctx.Lendings.AsNoTracking()
.OrderByDescending(p => p.Id)
.Select(c => new ListClassItem
{
Id = c.Id,
Nevisande = ctx.Books.Where(p => p.Id == c.BookId)
.Select(s => s.AuthorName).Single(),
BookSubject = ctx.Books.Where(x => x.Id == c.BookId)
.Select(s => s.Subject).Single(),
BookName = ctx.Books.Where(p => p.Id == c.BookId)
.Select(p => p.Title)
.Single()
})
.ToList();
}
}
private void BindDashboardData()
{
using (BookKeeper_DB_Context _context = new())
{
lblBooksNumber.Text = _context.Books.Count().ToString();
lblLendingCount.Text = _context.Lendings.Count().ToString();
lblMemberCount.Text = _context.Members.Count().ToString();
}
}
private void BindDashboardDataMember()
{
using (BookKeeper_DB_Context _context = new())
{
lblMemberCount.Text = _context.Members.Count().ToString();
}
}
private void tmTime_Tick(object sender, EventArgs e)
{
txtTime.Text = DateTime.Now.ToLongTimeString();
}
private void btnBookManagement_Click(object sender, EventArgs e)
{
frmBookManagement frmBookManagement = new();
frmBookManagement.ShowDialog();
BindDashboardData();
}
private void groupBox1_Enter(object sender, EventArgs e)
{
}
private void btnPersonsList_Click(object sender, EventArgs e)
{
frmMemberList frmMemberList = new frmMemberList();
frmMemberList.ShowDialog();
BindDashboardDataMember();
}
private void btnLend_Click(object sender, EventArgs e)
{
frmLendList frmLendList = new frmLendList();
frmLendList.ShowDialog();
BindDashboardData();
}
private void dgvLendBooks_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (BookKeeper_DB_Context context = new())
{
string Id = dgvLendBooks.CurrentRow.Cells[0].Value.ToString();
int lendId = Convert.ToInt32(Id);
dgvPersonLendingList.AutoGenerateColumns = false;
dgvPersonLendingList.DataSource = context.Lendings.
Where(s => s.Id == lendId)
.Select(f => new
{
BorrowerName = f.BorrowerName,
BorrowerPhone = f.BorrowerPhone,
LendDate = f.LendDate
}).ToList();
}
}
}
}
بسیار عالی