private void SaveBook_Click(object sender, EventArgs e)
{
Modelss.Book bok = new Modelss.Book();
using (Modelss.KITABXANADB db = new Modelss.KITABXANADB())
{
}
Modelss.Category ct = new Modelss.Category();
string bookN = bookname.Text.ToString();
string autor = cbAuthor.SelectedItem.ToString();
string pricee = bookprice.Text.ToString();
string ctg = categoryCB.SelectedItem.ToString();
string countt = bookcount.Text.ToString();
decimal dbprice = Convert.ToDecimal(bookprice.Text);
dgvBooks.Rows.Add(bookN, autor, pricee, ctg, countt);
bok.CategoryID = 2;
bok.Name = bookN;
bok.Price = dbprice;
bok.Count = Convert.ToInt32(countt);
using (Modelss.KITABXANADB db = new Modelss.KITABXANADB())
{
db.Books.Add(bok);
db.SaveChanges();
}
}
private void Button1_Click(object sender, EventArgs e)
{
using (Modelss.KITABXANADB db = new Modelss.KITABXANADB())
{
Modelss.Category ctgr = new Modelss.Category();
ctgr.Name = ctgrtxt.Text;
db.Categories.Add(ctgr);
db.SaveChanges();
}
ctgDVG.Rows.Add(ctgrtxt.Text);
}
private void Button1_Click(object sender, EventArgs e)
{
using (Modelss.KITABXANADB db = new Modelss.KITABXANADB())
{
List <Modelss.Author> authorr = db.Authors.ToList();
Modelss.Author auth = new Modelss.Author();
auth.Name = autname.Text;
auth.Surname = authSurname.Text;
db.Authors.Add(auth);
db.SaveChanges();
authorDVG.Rows.Add(autname.Text, authSurname.Text);
}
}
private void Button1_Click(object sender, EventArgs e)
{
string clName = CLname.Text;
string ClSurname = Clsurname.Text;
string email = mail.Text;
string phonee = tel.Text;
DVGclient.Rows.Add(clName, ClSurname, email, email, phonee);
Modelss.Client cl = new Modelss.Client();
using (Modelss.KITABXANADB db = new Modelss.KITABXANADB())
{
cl.Name = CLname.Text;
cl.Surname = Clsurname.Text;
cl.Email = mail.Text;
cl.Phone = tel.Text;
db.Clients.Add(cl);
cl.Status = true;
db.SaveChanges();
}
}
private void Orderbtn_Click(object sender, EventArgs e)
{
Modelss.Order ord = new Modelss.Order();
DateTime orderDate = DateTime.Now;
DateTime nextMonth = orderDate.AddDays(1).AddMonths(1).AddDays(-1);
int customerID = Convert.ToInt32(ClientsData.CurrentRow.Cells[0].Value);
int bookid = Convert.ToInt32(booksData.CurrentRow.Cells[0].Value);
ord.ClientID = customerID;
ord.BookID = bookid;
ord.OrderDate = orderDate;
ord.ReturnDate = nextMonth;
using (Modelss.KITABXANADB db = new Modelss.KITABXANADB())
{
MessageBox.Show("Created Order");
db.Orders.Add(ord);
db.SaveChanges();
}
}
