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));
}
