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 Order_Load(object sender, EventArgs e) { using (Modelss.KITABXANADB db = new Modelss.KITABXANADB()) { List <Modelss.Author> aut = db.Authors.ToList(); List <Modelss.Order> ord = db.Orders.ToList(); List <Modelss.Client> cll = db.Clients.ToList(); string ad, ad2; string soyad, soyad2; DateTime order, returndate; foreach (var item in cll) { dgvOrder.Rows.Add(item.Name); ad = db.Clients.Select(g => g.Name).ToString(); soyad = db.Clients.Select(g => g.Surname).ToString(); } foreach (var item in aut) { dgvOrder.Rows.Add(item.Name); ad2 = db.Authors.Select(g => g.Name).ToString(); soyad2 = db.Authors.Select(g => g.Surname).ToString(); } } }
private void Books_Load(object sender, EventArgs e) { using (Modelss.KITABXANADB db = new Modelss.KITABXANADB()) { cbAuthor.DataSource = db.Authors.Select(g => g.Name).ToList(); categoryCB.DataSource = db.Categories.Select(g => g.Name).ToList(); } }
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); }
public void SearchBook() { string SearchKey2 = txtBook.Text.Trim().ToLower(); using (Modelss.KITABXANADB db = new Modelss.KITABXANADB()) { List <Book> findBooks = db.Books.Where(c => c.Name.ToLower().Contains(SearchKey2)).ToList(); booksData.Rows.Clear(); foreach (var item2 in findBooks) { booksData.Rows.Add(item2.ID, item2.Name, item2.AuthorsBooks, item2.Price, item2.CategoryID, item2.Count); } } }
public void SearchUser() { string SearchKey = clSearch.Text.Trim().ToLower(); using (Modelss.KITABXANADB db = new Modelss.KITABXANADB()) { List <Client> findClients = db.Clients.Where(c => c.Name.ToLower().Contains(SearchKey) || c.Email.ToLower().Contains(SearchKey) || c.Phone.ToLower().Contains(SearchKey) || c.Surname.ToLower().Contains(SearchKey)).ToList(); ClientsData.Rows.Clear(); foreach (var item in findClients) { ClientsData.Rows.Add(item.ID, item.Name, item.Surname, item.Email, item.Phone); } } }
public void refreshDataGridView1() { MessageBox.Show("salam"); using (Modelss.KITABXANADB db = new Modelss.KITABXANADB()) { booksData.Rows.Clear(); List <Modelss.Book> books = db.Books.ToList(); foreach (var book in books) { booksData.Rows.Add(book.ID, book.Name, book.AuthorsBooks, book.Price, book.CategoryID, book.Count); } } }
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(); } }
public void CreateDVG() { using (Modelss.KITABXANADB db = new Modelss.KITABXANADB()) { List <Client> clients = db.Clients.ToList(); foreach (var client in clients) { ClientsData.Rows.Add(client.ID, client.Name, client.Surname, client.Email, client.Phone); } List <Book> books = db.Books.ToList(); List <AuthorsBook> authorB = db.AuthorsBooks.ToList(); List <Modelss.Author> authors = db.Authors.ToList(); foreach (var book in books) { booksData.Rows.Add(book.ID, book.Name, book.AuthorsBooks, book.Price, book.CategoryID, book.Count); } } }