public bool delete(vatphamdto vp) { string delete = string.Format("delete from VATPHAM where MAVP= @mavp"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@mavp", SqlDbType.Int); sqlParameters[0].Value = vp.Mavatpham; return(conn.executeDeleteQuery(delete, sqlParameters)); }
private void luusanpham_Click(object sender, EventArgs e) { string tenanh = tensanphamtxt.Text.Replace(" ", "") + DateTime.Now.ToString("ddmmyyyyhhmmss") + ".jpeg"; if (Directory.Exists(appPath) == false) { Directory.CreateDirectory(appPath); } if (pictureBox1 == null || pictureBox1.Image == null) { MessageBox.Show("khong co hinh"); tenanh = "default-product-image.jpg"; } else { pictureBox1.Image.Save(appPath + tenanh, ImageFormat.Jpeg); } vatphamdto vpdto = new vatphamdto(); vpdto.Tenvatpham = tensanphamtxt.Text; vpdto.Loaivatpham = loaisptxt.Text; vpdto.Hinhanh = tenanh; vpdto.Tukhoa = mieutatxt.Text; vpdto.Gia = Convert.ToDecimal(giatxt.Text); vatphambus vpbus = new vatphambus(); vpbus.add(vpdto); danhsachsanphamnhapdgv.DataSource = vpbus.listvatpham(vpdto.Tenvatpham); DataGridViewImageColumn ic = new DataGridViewImageColumn(); ic.HeaderText = "Hình ảnh"; ic.Image = null; ic.Name = "cImg"; ic.Width = 100; danhsachsanphamnhapdgv.Columns.Insert(0, ic); danhsachsanphamnhapdgv.Columns[2].Visible = false; foreach (DataGridViewRow row in danhsachsanphamnhapdgv.Rows) { DataGridViewImageCell cell = row.Cells[0] as DataGridViewImageCell; string path = "default-product-image.jpg"; try { path = row.Cells[2].Value.ToString(); } catch (Exception) { } path = appPath + path; Console.WriteLine(path); cell.Value = Bitmap.FromFile(path); row.Height = 100; } }
public bool add(vatphamdto vp) { string insert = string.Format("insert into VATPHAM (HINHANH,TENVP,LOAIVP,GIA,TUKHOA) values (@hinhanh,@tenvp,@loaivp,@gia,@tukhoa)"); SqlParameter[] sqlParameters = new SqlParameter[5]; sqlParameters[0] = new SqlParameter("@hinhanh", SqlDbType.NVarChar, 100); sqlParameters[0].Value = Convert.ToString(vp.Hinhanh); sqlParameters[1] = new SqlParameter("@tenvp", SqlDbType.NVarChar, 100); sqlParameters[1].Value = Convert.ToString(vp.Tenvatpham); sqlParameters[2] = new SqlParameter("@loaivp", SqlDbType.NVarChar, 15); sqlParameters[2].Value = Convert.ToString(vp.Loaivatpham); sqlParameters[3] = new SqlParameter("@gia", SqlDbType.Decimal); sqlParameters[3].Value = Convert.ToString(vp.Gia); sqlParameters[4] = new SqlParameter("@tukhoa", SqlDbType.NVarChar, 100); sqlParameters[4].Value = Convert.ToString(vp.Tukhoa); return(conn.executeInsertQuery(insert, sqlParameters)); }
public bool update(vatphamdto vp) { string update = string.Format("update VATPHAM SET HINHANH = @hinhanh, TENVP = @tenvp, LOAIVP = @loaivp, GIA = @gia, TUKHOA = @tukhoa WHERE MAVP = @mavp"); SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("@hinhanh", SqlDbType.NVarChar, 100); sqlParameters[0].Value = Convert.ToString(vp.Hinhanh); sqlParameters[1] = new SqlParameter("@tenvp", SqlDbType.NVarChar, 100); sqlParameters[1].Value = Convert.ToString(vp.Tenvatpham); sqlParameters[2] = new SqlParameter("@loaivp", SqlDbType.NVarChar, 15); sqlParameters[2].Value = Convert.ToString(vp.Loaivatpham); sqlParameters[3] = new SqlParameter("@gia", SqlDbType.Decimal); sqlParameters[3].Value = Convert.ToString(vp.Gia); sqlParameters[4] = new SqlParameter("@tukhoa", SqlDbType.NVarChar, 100); sqlParameters[4].Value = Convert.ToString(vp.Tukhoa); sqlParameters[5] = new SqlParameter("@mavp", SqlDbType.Int); sqlParameters[5].Value = Convert.ToString(vp.Mavatpham); return(conn.executeUpdateQuery(update, sqlParameters)); }
public bool delete(vatphamdto vatpham) { return(vpd.delete(vatpham)); }
public bool update(vatphamdto vatpham) { return(vpd.update(vatpham)); }
public bool add(vatphamdto vatpham) { return(vpd.add(vatpham)); }