Пример #1
0
 /// <summary>
 /// Them moi phong kham vao entities
 /// </summary>
 /// <param name="MAPHONGKHAM"></param>
 /// <param name="TENPHONG"></param>
 /// <param name="NGAYTAO"></param>
 /// <param name="TRANGTHAI"></param>
 public static void Insertphongkham(string MAPHONGKHAM, string TENPHONG, DateTime NGAYTAO, Boolean TRANGTHAI)
 {
     using (DB_HMS_Entities ds = new DB_HMS_Entities())
     {
         tbPHONGKHAM pk = new tbPHONGKHAM();
         pk.MAPHONGKHAM = MAPHONGKHAM;
         pk.TENPHONG    = TENPHONG;
         pk.NGAYTAO     = NGAYTAO;
         pk.TRANGTHAI   = TRANGTHAI;
         ds.AddTotbPHONGKHAMs(pk);
         ds.SaveChanges();
     }
 }
Пример #2
0
 /// <summary>
 /// cap nhat phong kham vao entities
 /// </summary>
 /// <param name="MAPHONGKHAM"></param>
 /// <param name="TENPHONG"></param>
 /// <param name="NGAYTAO"></param>
 /// <param name="TRANGTHAI"></param>
 public static void Updatephongkham(string MAPHONGKHAM, string TENPHONG, DateTime NGAYTAO, Boolean TRANGTHAI)
 {
     using (DB_HMS_Entities ds = new DB_HMS_Entities())
     {
         tbPHONGKHAM pk    = new tbPHONGKHAM();
         var         query = (from dss in ds.tbPHONGKHAMs
                              where dss.MAPHONGKHAM == MAPHONGKHAM
                              select dss).First();
         query.TENPHONG  = TENPHONG;
         query.NGAYTAO   = NGAYTAO;
         query.TRANGTHAI = TRANGTHAI;
         ds.SaveChanges();
     }
 }