public static void UpdateMaxacnhan(string MABENHAN, int MAXACNHAN)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbHOSOKHAMBENH pk = new tbHOSOKHAMBENH();
var query = (from dss in ds.tbHOSOKHAMBENHs
where dss.MAKHAMBENH == MABENHAN
select dss).First();
query.MAXACNHAN = MAXACNHAN;
ds.SaveChanges();
}
}
public static void UpdateBacsivaobenhan(string MABENHAN, string MABACSY)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbHOSOKHAMBENH pk = new tbHOSOKHAMBENH();
var query = (from dss in ds.tbHOSOKHAMBENHs
where dss.MAKHAMBENH == MABENHAN
select dss).First();
query.MABACSY = MABACSY;
ds.SaveChanges();
}
}
/// <summary>
/// Cập nhật bệnh vào database
/// </summary>
/// <param name="MABENH"></param>
/// <param name="MANHOMBENH"></param>
/// <param name="TENBENHTA"></param>
/// <param name="TENBENHTV"></param>
/// <param name="MOTA"></param>
/// <param name="NGAYTAO"></param>
/// <param name="TRANGTHAI"></param>
public static void UpdateTrangthai(string MABENHAN, int TRANGTHAI)
{
using (DB_HMS_Entities ds = new DB_HMS_Entities())
{
tbHOSOKHAMBENH pk = new tbHOSOKHAMBENH();
var query = (from dss in ds.tbHOSOKHAMBENHs
where dss.MAKHAMBENH == MABENHAN
select dss).First();
query.TRANGTHAI = TRANGTHAI;
ds.SaveChanges();
}
}
