private void accordionControlElement3_Click(object sender, EventArgs e) { try { bunifuCustomDataGrid2.Columns.Clear(); bunifuCustomDataGrid2.ReadOnly = true; _computers = new Computers(); if (_computers.GetShort().Rows.Count > 0) { bunifuCustomDataGrid2.DataSource = _computers.GetShort(); //AddButton(bunifuCustomDataGrid2); var name = bunifuCustomDataGrid2.Rows[0].Cells[0].Value.ToString(); var price = int.Parse(bunifuCustomDataGrid2.Rows[0].Cells[1].Value.ToString()); var brand = bunifuCustomDataGrid2.Rows[0].Cells[3].Value.ToString(); var gpu = bunifuCustomDataGrid2.Rows[0].Cells[4].Value.ToString(); var os = bunifuCustomDataGrid2.Rows[0].Cells[7].Value.ToString(); var ram = bunifuCustomDataGrid2.Rows[0].Cells[6].Value.ToString(); var date = bunifuCustomDataGrid2.Rows[0].Cells[2].Value.ToString(); var cpu = bunifuCustomDataGrid2.Rows[0].Cells[5].Value.ToString(); label51.Text = gpu; label50.Text = os; label49.Text = ram; label36.Text = price.ToString(); label37.Text = brand; label47.Text = name; label48.Text = date; label35.Text = cpu; byte[] img; if (_computers.GetByName(label47.Text, "Computers").Rows[0][12].ToString() != "NULL") { img = (byte[])(_computers.GetByName(label47.Text, "Computers").Rows[0][12]); if (img == null) { pictureBox17.Image = null; } else { var ms = new MemoryStream(img); pictureBox17.Image = Image.FromStream(ms); } } } xtraTabPage7.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void GetComputerInfo(string s) { try { var name = tName.Text.Trim(); var price = int.Parse(tPrice.Text.Trim()); var piece = int.Parse(tPiece.Text.Trim()); var date = tDate.Text.Trim(); var brand = tBrand.Text.Trim(); var gpu = tGPU.Text.Trim(); var cpu = tCPU.Text.Trim(); var ram = int.Parse(tRAM.Text.Trim()); var ss = float.Parse(tSS.Text.Trim()); var os = tOS.Text.Trim(); var fs = new FileStream(imgLoc, FileMode.Open, FileAccess.Read); var br = new BinaryReader(fs); img = br.ReadBytes((int)fs.Length); switch (s) { case "add": { var result = _comp.GetByName(name, "Computers"); if (result.Rows.Count > 0) { lberror.ForeColor = Color.Red; lberror.Text = CommonFunctions.ReturnString("exist"); } else { _comp.Add(name, gpu, price, piece, date, brand, cpu, ram, ss, os); _product.AddImage(int.Parse(_product.GetByName(name, "Computers").Rows[0][0].ToString()), img, "Computers"); lberror.ForeColor = Color.Green; lberror.Text = CommonFunctions.ReturnString("success"); } break; } case "update": { var id = int.Parse(tID.Text.Trim()); _comp.Update(id, name, gpu, price, piece, date, brand, cpu, ram, ss, os); _comp.AddImage(id, img, "Computers"); break; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void bunifuCustomDataGrid2_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex > -1) { var name = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[0].Value.ToString(); var price = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[1].Value.ToString(); var brand = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[3].Value.ToString(); var gpu = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[4].Value.ToString(); var os = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[7].Value.ToString(); var ram = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[6].Value.ToString(); var date = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[2].Value.ToString(); var cpu = bunifuCustomDataGrid2.Rows[e.RowIndex].Cells[5].Value.ToString(); label51.Text = gpu; label50.Text = os; label49.Text = ram; label36.Text = price; label37.Text = brand; label47.Text = name; label48.Text = date; label35.Text = cpu; byte[] img; if (_computers.GetByName(label47.Text, "Computers").Rows[0][12].ToString() == "NULL") { return; } img = (byte[])(_computers.GetByName(label47.Text, "Computers").Rows[0][12]); if (img == null) { pictureBox17.Image = null; } else { var ms = new MemoryStream(img); pictureBox17.Image = Image.FromStream(ms); } } }
private void button1_Click(object sender, EventArgs e) { if (cb.SelectedIndex == 0) { if (searchID.Text.Trim() == "" && searchName.Text.Trim() == "") { searchError.Text = "Parameters can not be empty."; } else { if (searchID.Text.Trim() != "" && searchName.Text.Trim() == "") { dataGridView1.DataSource = comp.GetById(int.Parse(searchID.Text.Trim()), "Computers"); } else if (searchID.Text.Trim() == "" && searchName.Text.Trim() != "") { dataGridView1.DataSource = comp.GetByName(searchName.Text.Trim(), "Computers"); } else { searchError.Text = "You can only search with only one parameter"; } } } else if (cb.SelectedIndex == 1) { if (searchID.Text.Trim() == "" && searchName.Text.Trim() == "") { searchError.Text = "Parameters can not be empty."; } else { if (searchID.Text.Trim() != "" && searchName.Text.Trim() == "") { dataGridView1.DataSource = SmartPhones.GetById(int.Parse(searchID.Text.Trim()), "SmartPhones"); } else if (searchID.Text.Trim() == "" && searchName.Text.Trim() != "") { dataGridView1.DataSource = SmartPhones.GetByName(searchName.Text.Trim(), "SmartPhones"); } else { searchError.Text = "You can only search with only one parameter"; } } } else if (cb.SelectedIndex == 2) { if (searchID.Text.Trim() == "" && searchName.Text.Trim() == "") { searchError.Text = "Parameters can not be empty."; } else { if (searchID.Text.Trim() != "" && searchName.Text.Trim() == "") { dataGridView1.DataSource = MusicBook.GetById(int.Parse(searchID.Text.Trim()), "MusicBook"); } else if (searchID.Text.Trim() == "" && searchName.Text.Trim() != "") { dataGridView1.DataSource = MusicBook.GetByName(searchName.Text.Trim(), "MusicBook"); } else { searchError.Text = "You can only search with only one parameter"; } } } else { searchError.Text = "Please select a category."; } }