با سلام
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;
}
}
🌹
عالی عمل کردی
بسیار ازتون متشکرم 🌹🙏