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(); } }