public static void UpdateDonthuocchitiet(string MADONTHUOCMAU, string MABACSI, string MATHUOC, string SOLUONG, string SOLANDUNG, string SOLUONGDUNG, DateTime NGAYTAO)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbDONTHUOCMAUCHITIET pk = new tbDONTHUOCMAUCHITIET();
var query = (from dss in ds.tbDONTHUOCMAUCHITIETs
where dss.MADONTHUOCMAU == MADONTHUOCMAU && dss.MABACSI == MABACSI && dss.MATHUOC == MATHUOC
select dss).First();
//query.MABENH = MABENH;
query.SOLUONG = Int32.Parse(SOLUONG);
query.SOLANDUNG = Int32.Parse(SOLANDUNG);
query.SOLUONGDUNG = Int32.Parse(SOLUONGDUNG);
query.NGAYTAO = NGAYTAO;
ds.SaveChanges();
}
}
public static void InsertDonthuocchitiet(string MADONTHUOCMAU, string MABACSI, string MATHUOC, string SOLUONG, string SOLANDUNG, string SOLUONGDUNG, DateTime NGAYTAO)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbDONTHUOCMAUCHITIET pk = new tbDONTHUOCMAUCHITIET();
pk.MADONTHUOCMAU = MADONTHUOCMAU;
pk.MABACSI = MABACSI;
pk.MATHUOC = MATHUOC;
pk.SOLUONG = Int32.Parse(SOLUONG);
pk.SOLANDUNG = Int32.Parse(SOLANDUNG);
pk.SOLUONGDUNG = Int32.Parse(SOLUONGDUNG);
pk.NGAYTAO = NGAYTAO;
ds.AddTotbDONTHUOCMAUCHITIETs(pk);
ds.SaveChanges();
}
}
