public static tbl_CheckWarehouse GetByID(int ID)
 {
     using (var dbe = new inventorymanagementEntities())
     {
         tbl_CheckWarehouse ai = dbe.tbl_CheckWarehouse.Where(a => a.ID == ID).SingleOrDefault();
         if (ai != null)
         {
             return(ai);
         }
         else
         {
             return(null);
         }
     }
 }
 public static string Insert(int AgentID, int Type, string Note, DateTime CreatedDate, string CreatedBy)
 {
     using (var dbe = new inventorymanagementEntities())
     {
         tbl_CheckWarehouse ui = new tbl_CheckWarehouse();
         ui.AgentID     = AgentID;
         ui.Type        = Type;
         ui.Note        = Note;
         ui.CreatedDate = CreatedDate;
         ui.CreatedBy   = CreatedBy;
         dbe.tbl_CheckWarehouse.Add(ui);
         int kq = dbe.SaveChanges();
         return(kq.ToString());
     }
 }