public static void UpdateLoaiSanPham(LoaiSanPhamModel loaiSP)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("update LoaiSanPham set MADVT=@MaDVT,PHANTRAMLOINHUAN=@PhanTramLoiNhuan, TENLOAISP = @TenLoaiSP WHERE MALOAISP = @maLoaiSP", loaiSP);
}
}
public static void RemoveLoaiSanPham(LoaiSanPhamModel loaiSP)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("DELETE FROM LoaiSanPham WHERE MALOAISP = @maLoaiSP", loaiSP);
}
}
public static long SaveLoaiSanPham(LoaiSanPhamModel loaiSP)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
long lastRowID = (long)cnn.ExecuteScalar("insert into LoaiSanPham(MADVT,PHANTRAMLOINHUAN, TENLOAISP) values (@MaDVT,@PhanTramLoiNhuan,@TenLoaiSP); SELECT last_insert_rowid()", loaiSP);
//lastRowID dùng để xác định ID của một hàng vừa được thêm vào.
return(lastRowID);
}
}
