public static void UpdateLoaiDichVu(LoaiDichVuModel loaiDV)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("update LoaiDichVu set TENLOAIDV = @TenLoaiDV , DONGIADV = @DonGiaDV WHERE MALOAIDV = @maLoaiDV", loaiDV);
}
}
public static void RemoveLoaiDichVu(LoaiDichVuModel loaiDV)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("DELETE FROM LOAIDICHVU WHERE MALOAIDV = @maLoaiDV", loaiDV);
}
}
public static long SaveLoaiDichVu(LoaiDichVuModel loaiDV)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
long lastRowID = (long)cnn.ExecuteScalar("insert into LoaiDichVu(TENLOAIDV,DONGIADV) values (@TenLoaiDV,@DonGiaDV); SELECT last_insert_rowid()", loaiDV);
//lastRowID dùng để xác định ID của một hàng vừa được thêm vào.
return(lastRowID);
}
}