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