private void Show_Table() { this.button1_Edit.Visible = false; this.button1_Delete.Visible = false; this.listView1_Disc.Items.Clear(); using (MusicEntities2 db = new MusicEntities2()) { var disc = db.Disc.Select(z => z).ToList(); list = disc; string[] row = new string[10]; foreach (var VARIABLE in list) { row[0] = VARIABLE.Id.ToString(); row[1] = VARIABLE.Pichuri; row[2] = VARIABLE.DiskName; row[3] = VARIABLE.ColectiveName; row[4] = VARIABLE.IzdatelName; row[5] = VARIABLE.ColTrec.ToString(); row[6] = VARIABLE.Genre; row[7] = VARIABLE.YearPublishing.ToString("d"); row[8] = VARIABLE.Cost_price.ToString(); row[9] = VARIABLE.Price.ToString(); ListViewItem itm = new ListViewItem(row); this.listView1_Disc.Items.Add(itm); } } }
private void Show_Home() { using (MusicEntities2 db = new MusicEntities2()) { var discs = db.Checkk.Select(z => z).ToList(); Show(discs); } }
private void Button1_Dey_Click(object sender, EventArgs e) { using (MusicEntities2 db = new MusicEntities2()) { var disc = db.Checkk.Where(z => z.DataSale.Day == data.Day).ToList(); Show(disc); } }
private void Show_Log() { using (MusicEntities2 db = new MusicEntities2()) { var log = db.LoginPassword.FirstOrDefault(z => z.Id == 1); this.textBox1_Login.Text = log.Login; this.textBox1_Password.Text = log.Password; } }
private void Button1_Delete_Click(object sender, EventArgs e) { int index = this.listView1_Disc.FocusedItem.Index; Disc disc = list[index]; using (MusicEntities2 db = new MusicEntities2()) { var find = db.Disc.FirstOrDefault(z => z.Id == disc.Id); db.Disc.Remove(find); db.SaveChanges(); } Show_Table(); }
private void Serch_DiscName() { if (this.textBox1_Serch.Text != "") { start = this.textBox1_Serch.Text; this.textBox1_Serch.Text = ""; } using (MusicEntities2 db = new MusicEntities2()) { var disc = db.Disc.Where(z => z.DiskName.StartsWith(start)).OrderBy(z => z.Id).Skip((pagesSerch - 1) * panal_col).Take(panal_col).ToList(); Show_Serch(disc); } }
private void List_Korzina(object sender, EventArgs e) { using (MusicEntities2 db = new MusicEntities2()) { Button button = sender as Button; if (button.Name == this.button1_Add1.Name) { int id = Convert.ToInt32(this.label13_Id1.Text); var disc = db.Disc.FirstOrDefault(z => z.Id == id); if (disc != null) { korzina.Add(disc); } } else if (button.Name == this.button1_Add2.Name) { int id = Convert.ToInt32(this.label13_Id2.Text); var disc = db.Disc.FirstOrDefault(z => z.Id == id); if (disc != null) { korzina.Add(disc); } } else if (button.Name == this.button1_Add3.Name) { int id = Convert.ToInt32(this.label13_Id3.Text); var disc = db.Disc.FirstOrDefault(z => z.Id == id); if (disc != null) { korzina.Add(disc); } } else if (button.Name == this.button1_Add4.Name) { int id = Convert.ToInt32(this.label13_Id4.Text); var disc = db.Disc.FirstOrDefault(z => z.Id == id); if (disc != null) { korzina.Add(disc); } } } this.label2_col.Text = korzina.Count.ToString(); }
private void Button1_Vhod_Click(object sender, EventArgs e) { using (MusicEntities2 db = new MusicEntities2()) { var Log_Pas = db.LoginPassword.Where(z => z.Login == this.textBox1_Login.Text && z.Password == this.textBox1_Password.Text).ToList(); if (Log_Pas.Count == 0) { this.textBox1_Login.Text = null; this.textBox1_Password.Text = null; this.label4_Error.Visible = true; } else { this.panel2_Zashita.Visible = false; } } }
private void Show_Table() { this.listView1_Pocupatel.Items.Clear(); using (MusicEntities2 db = new MusicEntities2()) { var disc = db.Buyer.Select(z => z).ToList(); string[] row = new string[4]; foreach (var VARIABLE in disc) { row[0] = VARIABLE.Id.ToString(); row[1] = VARIABLE.FersName; row[2] = VARIABLE.LastName; row[3] = VARIABLE.Col.ToString(); ListViewItem itm = new ListViewItem(row); this.listView1_Pocupatel.Items.Add(itm); } } }
private void Edit_database() { using (MusicEntities2 db = new MusicEntities2()) { var disc = db.Disc.FirstOrDefault(z => z.Id == disc_disc.Id); disc.ColectiveName = this.textBox1_ColectivName.Text; disc.ColTrec = col; disc.Cost_price = seb_pr; disc.DiskName = this.textBox1_NameDisc.Text; disc.Genre = this.textBox1_Gener.Text; disc.IzdatelName = this.textBox1_Izdatel.Text; disc.Pichuri = this.textBox1_img.Text; disc.Price = pr; disc.YearPublishing = date; db.Disc.AddOrUpdate(disc); db.SaveChanges(); } this.DialogResult = DialogResult.OK; }
private void Button1_Edit_Click(object sender, EventArgs e) { if (this.textBox1_Login.Text == "" || this.textBox1_Password.Text == "") { MessageBox.Show("Заполните все поля", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } using (MusicEntities2 db = new MusicEntities2()) { var log = db.LoginPassword.FirstOrDefault(z => z.Id == 1); log.Login = this.textBox1_Login.Text; log.Password = this.textBox1_Password.Text; db.LoginPassword.AddOrUpdate(log); db.SaveChanges(); } MessageBox.Show("Данные администратора изменены!", "Оповещение", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; }
private void Add_database() { using (MusicEntities2 db = new MusicEntities2()) { Disc disc = new Disc { ColectiveName = this.textBox1_ColectivName.Text, ColTrec = col, Cost_price = seb_pr, DiskName = this.textBox1_NameDisc.Text, Genre = this.textBox1_Gener.Text, IzdatelName = this.textBox1_Izdatel.Text, Pichuri = this.textBox1_img.Text, Price = pr, YearPublishing = date }; db.Disc.Add(disc); db.SaveChanges(); } this.DialogResult = DialogResult.OK; }
private void Oformlenie(List <Disc> discs, string lastName, string ferstName) { using (MusicEntities2 db = new MusicEntities2()) { var user = db.Buyer.Where(z => z.LastName == lastName && z.FersName == ferstName).ToList(); if (user.Count != 0) { foreach (Buyer VARIABLE in user) { int col = VARIABLE.Col; col += discs.Count; VARIABLE.Col = col; db.Buyer.AddOrUpdate(VARIABLE); db.SaveChanges(); } } else { Buyer buyer = new Buyer { Col = discs.Count, LastName = lastName, FersName = ferstName }; db.Buyer.Add(buyer); db.SaveChanges(); } } using (MusicEntities2 db = new MusicEntities2()) { var user = db.Buyer.Where(z => z.LastName == lastName && z.FersName == ferstName).ToList(); foreach (var VARIABLE in user) { var sumPrise = db.Checkk.Where(z => z.IdBuyer == VARIABLE.Id).Select(z => z.Summa).ToList(); decimal sum = 0; foreach (decimal VAR in sumPrise) { sum += VAR; } if (sum > 2000) { decimal s = 0; decimal nous = 0; this.panel1_Scidka.Visible = true; foreach (var V in discs) { decimal pr = 0; s += V.Price; pr = (V.Price - 15); nous = nous + (V.Price - 15); Checkk checkk = new Checkk { DataSale = DateTime.Now.Date, IdDisc = V.Id, IdBuyer = VARIABLE.Id, Summa = pr }; db.Checkk.Add(checkk); } db.SaveChanges(); this.label3_summ.Text = s.ToString(); this.label4_Scidka.Text = nous.ToString(); } else { decimal s = 0; this.panel1_NoScidca.Visible = true; foreach (var V in discs) { s += V.Price; Checkk checkk = new Checkk { DataSale = DateTime.Now.Date, IdDisc = V.Id, IdBuyer = VARIABLE.Id, Summa = V.Price }; db.Checkk.Add(checkk); } db.SaveChanges(); this.label6_NoScidka.Text = s.ToString(); } } } }
private void Show_Tovar() { panel1.Visible = false; panel2.Visible = false; panel3.Visible = false; panel4.Visible = false; panel5_Hit1.Visible = false; panel5_Hit2.Visible = false; panel6_Hit3.Visible = false; panel7_Hit4.Visible = false; using (MusicEntities2 db = new MusicEntities2()) { int col_poz = 0; var disc = db.Disc.OrderBy(z => z.Id).Skip((pages - 1) * panal_col).Take(panal_col).ToList(); if (disc.Count < 4) { this.button1_Two.Visible = false; this.button1_Right.Visible = false; } else { this.button1_Two.Visible = true; this.button1_Right.Visible = true; } foreach (var disc1 in disc) { if (col_poz == 0) { var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList(); if (hit.Count > 10) { panel5_Hit1.Visible = true; } panel1.Visible = true; try { Bitmap bitmap = new Bitmap(disc1.Pichuri); this.pictureBox2_1.Image = bitmap; } catch (Exception e) { Bitmap bitmap = new Bitmap(@"..\..\imagesMusic\ErrorImg.png"); this.pictureBox2_1.Image = bitmap; } this.pictureBox2_1.SizeMode = PictureBoxSizeMode.StretchImage; this.label12_Author1.Text = disc1.ColectiveName; this.label12_DiscName1.Text = disc1.DiskName; this.label12_Izdatel1.Text = disc1.IzdatelName; this.label12_Col_Trec1.Text = disc1.ColTrec.ToString(); this.label12_Ganr1.Text = disc1.Genre; this.label12_God1.Text = disc1.YearPublishing.ToString("d"); this.label13_Prise1.Text = disc1.Price.ToString(); this.label13_Id1.Text = disc1.Id.ToString(); } else if (col_poz == 1) { var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList(); if (hit.Count > 10) { panel5_Hit2.Visible = true; } panel2.Visible = true; try { Bitmap bitmap = new Bitmap(disc1.Pichuri); this.pictureBox3_2.Image = bitmap; } catch (Exception e) { Bitmap bitmap = new Bitmap(@"..\..\imagesMusic\ErrorImg.png"); this.pictureBox3_2.Image = bitmap; } this.pictureBox3_2.SizeMode = PictureBoxSizeMode.StretchImage; this.label12_Author2.Text = disc1.ColectiveName; this.label12_DiscName2.Text = disc1.DiskName; this.label12_Izdatel2.Text = disc1.IzdatelName; this.label12_Col_Trec2.Text = disc1.ColTrec.ToString(); this.label12_Ganr2.Text = disc1.Genre; this.label12_God2.Text = disc1.YearPublishing.ToString("d"); this.label13_Prise2.Text = disc1.Price.ToString(); this.label13_Id2.Text = disc1.Id.ToString(); } else if (col_poz == 2) { var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList(); if (hit.Count > 10) { panel6_Hit3.Visible = true; } panel3.Visible = true; try { Bitmap bitmap = new Bitmap(disc1.Pichuri); this.pictureBox4_3.Image = bitmap; } catch (Exception e) { Bitmap bitmap = new Bitmap(@"..\..\imagesMusic\ErrorImg.png"); this.pictureBox4_3.Image = bitmap; } this.pictureBox4_3.SizeMode = PictureBoxSizeMode.StretchImage; this.label12_Author3.Text = disc1.ColectiveName; this.label12_DiscName3.Text = disc1.DiskName; this.label12_Izdatel3.Text = disc1.IzdatelName; this.label12_Col_Trec3.Text = disc1.ColTrec.ToString(); this.label12_Ganr3.Text = disc1.Genre; this.label12_God3.Text = disc1.YearPublishing.ToString("d"); this.label13_Prise3.Text = disc1.Price.ToString(); this.label13_Id3.Text = disc1.Id.ToString(); } else if (col_poz == 3) { var hit = db.Checkk.Where(z => z.IdDisc == disc1.Id).ToList(); if (hit.Count > 10) { panel7_Hit4.Visible = true; } panel4.Visible = true; try { Bitmap bitmap = new Bitmap(disc1.Pichuri); this.pictureBox5_4.Image = bitmap; } catch (Exception e) { Bitmap bitmap = new Bitmap(@"..\..\imagesMusic\ErrorImg.png"); this.pictureBox5_4.Image = bitmap; } this.pictureBox5_4.SizeMode = PictureBoxSizeMode.StretchImage; this.label12_Author4.Text = disc1.ColectiveName; this.label12_DiscName4.Text = disc1.DiskName; this.label12_Izdatel4.Text = disc1.IzdatelName; this.label12_Col_Trec4.Text = disc1.ColTrec.ToString(); this.label12_Ganr4.Text = disc1.Genre; this.label12_God4.Text = disc1.YearPublishing.ToString("d"); this.label13_Prise4.Text = disc1.Price.ToString(); this.label13_Id4.Text = disc1.Id.ToString(); } col_poz++; } } }