• 1405/08/17

تمرین جلسه 116 ساختن گزارشات صفحه اول نرم افزار :

با سلام
 

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();
            }
        }
    }
}
  • 1405/08/17
  • ساعت 13:55

بسیار عالی