/// <summary>
/// Deprecated Method for adding a new object to the tbHOSOKHAMBENHs EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotbHOSOKHAMBENHs(tbHOSOKHAMBENH tbHOSOKHAMBENH)
{
base.AddObject("tbHOSOKHAMBENHs", tbHOSOKHAMBENH);
}
/// <summary>
/// Create a new tbHOSOKHAMBENH object.
/// </summary>
/// <param name="mAKHAMBENH">Initial value of the MAKHAMBENH property.</param>
/// <param name="mABENHNHAN">Initial value of the MABENHNHAN property.</param>
/// <param name="mAPHONGKHAM">Initial value of the MAPHONGKHAM property.</param>
public static tbHOSOKHAMBENH CreatetbHOSOKHAMBENH(global::System.String mAKHAMBENH, global::System.String mABENHNHAN, global::System.String mAPHONGKHAM)
{
tbHOSOKHAMBENH tbHOSOKHAMBENH = new tbHOSOKHAMBENH();
tbHOSOKHAMBENH.MAKHAMBENH = mAKHAMBENH;
tbHOSOKHAMBENH.MABENHNHAN = mABENHNHAN;
tbHOSOKHAMBENH.MAPHONGKHAM = mAPHONGKHAM;
return tbHOSOKHAMBENH;
}
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();
}
}
/// <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();
}
}
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();
}
}