public bool update(loaidto loai) { string update = string.Format("update LOAI SET TENLOAI = @tenloai WHERE MALOAI = @maloai"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@tenloai", SqlDbType.NVarChar, 50); sqlParameters[0].Value = Convert.ToString(loai.Tenloai); sqlParameters[1] = new SqlParameter("@maloai", SqlDbType.NVarChar, 15); sqlParameters[1].Value = Convert.ToString(loai.Maloai); return(conn.executeUpdateQuery(update, sqlParameters)); }
public bool update(thanhphodto thanhpho) { string update = string.Format("update THANHPHO SET TENTP = @tentp WHERE MATP = @matp"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@tentp", SqlDbType.NVarChar, 100); sqlParameters[0].Value = Convert.ToString(thanhpho.Tenthanhpho); sqlParameters[1] = new SqlParameter("@matp", SqlDbType.NVarChar, 15); sqlParameters[1].Value = Convert.ToString(thanhpho.Mathanhpho); return(conn.executeUpdateQuery(update, sqlParameters)); }
public bool update(nhaphangdto nhaphang) { string update = string.Format("update NHAPHANG SET NGAYNHAPHANG = @ngaynh, MACHINHANH = @machinhanh WHERE MANHAPHANG = @manh"); SqlParameter[] sqlParameters = new SqlParameter[3]; sqlParameters[0] = new SqlParameter("@ngaynh", SqlDbType.Date); sqlParameters[0].Value = Convert.ToString(nhaphang.Ngaynhaphang); sqlParameters[1] = new SqlParameter("@manh", SqlDbType.NVarChar, 15); sqlParameters[1].Value = Convert.ToString(nhaphang.Manhaphang); sqlParameters[2] = new SqlParameter("@machinhanh", SqlDbType.Int); sqlParameters[2].Value = nhaphang.Machinhanh; return(conn.executeUpdateQuery(update, sqlParameters)); }
public bool update(cuahangdto cuahang) { string update = string.Format("update CUAHANG SET TENCHINHANH = @tencuahang, DIACHI = @diachi, MATP = @matp WHERE MACUAHANG = @machinhanh"); SqlParameter[] sqlParameters = new SqlParameter[4]; sqlParameters[0] = new SqlParameter("@tenchinhanh", SqlDbType.NVarChar, 100); sqlParameters[0].Value = Convert.ToString(cuahang.Tenchinhanh); sqlParameters[1] = new SqlParameter("@diachi", SqlDbType.NVarChar, 100); sqlParameters[1].Value = Convert.ToString(cuahang.Diachi); sqlParameters[2] = new SqlParameter("@matp", SqlDbType.NVarChar, 15); sqlParameters[2].Value = Convert.ToString(cuahang.Matp); sqlParameters[3] = new SqlParameter("@macuahang", SqlDbType.Int); sqlParameters[3].Value = cuahang.Machinhanh; return(conn.executeUpdateQuery(update, sqlParameters)); }
public bool update(tonkhodto tonkho) { string update = string.Format("update TONKHO SET MAVP= @mavp, NGAYHETHAN= @ngayhethan, SOLUONGNHAP= @slnhap, SOLUONGTON= @slton WHERE MANHAPHANG = @manh"); SqlParameter[] sqlParameters = new SqlParameter[5]; sqlParameters[0] = new SqlParameter("@mavp", SqlDbType.Int); sqlParameters[0].Value = Convert.ToString(tonkho.Mavp); sqlParameters[1] = new SqlParameter("@ngayhethan", SqlDbType.Date); sqlParameters[1].Value = Convert.ToString(tonkho.Ngayhethan); sqlParameters[2] = new SqlParameter("@slnhap", SqlDbType.Int); sqlParameters[2].Value = Convert.ToString(tonkho.Soluongnhap); sqlParameters[3] = new SqlParameter("@slton", SqlDbType.Int); sqlParameters[3].Value = Convert.ToString(tonkho.Soluongton); sqlParameters[4] = new SqlParameter("@manh", SqlDbType.NVarChar, 15); sqlParameters[4].Value = Convert.ToString(tonkho.Manhaphang); return(conn.executeUpdateQuery(update, 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)); }