private void btnDelete_Click(object sender, EventArgs e) { if (dgvProductImage.SelectedRows.Count <= 0) { return; } DialogResult dr = MessageBox.Show("Are you sure ?", "Confirmation", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (dr != DialogResult.Yes) { return; } DAL.ProductImage pi = new DAL.ProductImage(); pi.Id = Convert.ToInt32(dgvProductImage.SelectedRows[0].Cells["colId"].Value); if (pi.delete()) { MessageBox.Show("Data has been Deleted"); btnSearch.PerformClick(); } else { MessageBox.Show(pi.Error); } }
private void btnSave_Click(object sender, EventArgs e) { ep.Clear(); int er = 0; if (cmbProduct.SelectedValue == null || cmbProduct.SelectedValue.ToString() == "") { er++; ep.SetError(cmbProduct, "Select Product"); } if (pbImage.Image == null) { er++; ep.SetError(pbImage, "Select Image"); } if (er >= 0) { return; } DAL.ProductImage pi = new DAL.ProductImage(); pi.ProductId = Convert.ToInt32(cmbProduct.SelectedValue); pi.Title = txtTitle.Text; pi.FileName = pbImage.Tag.ToString(); pi.Image = MyControls.FileImage.ImageToByte(pbImage.Image); if (pi.Insert()) { MessageBox.Show("Data Saved"); MyControls.Helper.clear(this); } else { MessageBox.Show(pi.Error); } }
private void btnSearch_Click(object sender, EventArgs e) { DAL.ProductImage pi = new DAL.ProductImage(); pi.Search = txtSearch.Text; try { pi.ProductId = Convert.ToInt32(cmbProduct.SelectedValue); } catch { } dgvProductImage.DataSource = pi.select().Tables[0]; }
private void btnSave_Click(object sender, EventArgs e) { int er = 0; ep.Clear(); if (cmbProduct.SelectedValue == null || cmbProduct.SelectedValue.ToString() == "") { er++; ep.SetError(cmbProduct, "Requred"); } if (txtTitle.Text == "") { er++; ep.SetError(txtTitle, "Required"); } if (pbImage.Image == null) { er++; ep.SetError(pbImage, "Required"); } if (er > 0) { return; } DAL.ProductImage pi = new DAL.ProductImage(); pi.ProductId = Convert.ToInt32(cmbProduct.SelectedValue); pi.Title = txtTitle.Text; pi.Image = BDJBatch18.POS.FimeImage.ImageToByte(pbImage.Image); if (pi.insert()) { MessageBox.Show("Image Saved"); cmbProduct.SelectedValue = -1; txtTitle.Text = ""; pbImage.Image = null; cmbProduct.Focus(); } else { MessageBox.Show(pi.Error); } }
private void btnSearch_Click(object sender, EventArgs e) { DAL.ProductImage pi = new DAL.ProductImage(); dgvData.DataSource = pi.Select().Tables[0]; }