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