示例#1
0
 public bool updateStatus(int id, int key)
 {
     using (TestTEduDbEntities db = new TestTEduDbEntities())
     {
         var result = from a in db.RoomTbs
                      where a.ID_room == id
                      select a;
         if (result == null)
         {
             return(false);
         }
         try
         {
             if (key == 1)
             {
                 result.SingleOrDefault().Status = 1;
             }
             else
             {
                 result.SingleOrDefault().Status = 0;
             }
             db.Entry(result.SingleOrDefault()).State = System.Data.Entity.EntityState.Modified;
             db.SaveChanges();
         }
         catch (Exception ex)
         {
             return(false);
         }
         return(true);
     }
 }
 public bool CheckStatus(int id)
 {
     using (TestTEduDbEntities db = new TestTEduDbEntities())
     {
         var check = from a in db.RoomTbs
                     where a.ID_room == id && a.Status == 1
                     select a;
         return((check != null) ? true : false);// neu phong con trong = true
     }
 }