• 1405/06/24

تمرین جلسه 102 - گزارش سیستم و مدل ها :

با سلام

frmMain.cs :

using BookKeeper.Books;
using DataLayer.Context;
using DataLayer.SeedData;
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;

namespace BookKeeper
{
    public partial class frmMain : Form
    {
        BookKeeper_DB_Context _context = new();
        public frmMain()
        {
            InitializeComponent();
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            txtDateTimeNow.Text = $"امروز {DateTime.Now.ToShamsi()}";
            txtTime.Text = DateTime.Now.ToLongTimeString();
            BookKeeperSeedData.SeedData();
            BindDashboardData();
        }
        private void BindDashboardData()
        {
            lblBooksNumber.Text = _context.Books.Count().ToString();
            lblLendingCount.Text = _context.Lendings.Count().ToString();
            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();
        }

        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }
    }
}

Models :

Books.cs:

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Text;

namespace DataLayer.Models
{
    public class Book
    {
        [Key]
        public int Id { get; set; }

        [MaxLength(50)]
        public string Title { get; set; }

        [MaxLength(20)]
        public string Subject { get; set; }

        [MaxLength(30)]
        public string AuthorName { get; set; }

        [MaxLength(500)]
        public string? Description { get; set; }

        public int Rating { get; set; } = 3;
        public bool IsAvailable { get; set; }
        public bool IsFavorite { get; set; }
        public bool IsWishlist { get; set; }
        public DateTime AddedDate { get; set; } = DateTime.Now;
    }
}

Lending.cs :

using System;
using System.Collections.Generic;
using System.Text;

namespace DataLayer.Models
{
    public class Lending
    {
        public int Id { get; set; }
        public int BookId { get; set; }
        public string BorrowerName { get; set; }
        public string? BorrowerPhone { get; set; }
        public DateTime LendDate { get; set; } = DateTime.Now;
        public DateTime? ExpectedReturnDate { get; set; }
        public bool IsReturned { get; set; } = false;
    }
}

Member.cs :

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Text;

namespace DataLayer.Models
{
    public class Member
    {
        [Key]
        public int MemberId { get; set; }

        [MaxLength(150)]
        public string Name { get; set; }

        [MaxLength(150)]
        public string Family { get; set; }

        [MaxLength(100)]
        public string Mobile { get; set; }

        [MaxLength(100)]
        public string? Email { get; set; }

        public DateTime MembershipDate { get; set; } = DateTime.Now;
    }
}

🌹

  • 1405/06/24
  • ساعت 11:27

عالی عمل کردی 


  • 1405/06/24
  • ساعت 13:08

بسیار ازتون متشکرم 🌹🙏