Пример #1
0
 // get restaurant id from restaurant table instead?
 public Deal Get_Restaurant_ID(int Restaurant_ID)
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Deals.FirstOrDefault(e => e.Restaurant_ID == Restaurant_ID));
     }
 }
Пример #2
0
 public Deal Get_Start_Date(DateTime Start_Time)
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Deals.FirstOrDefault(e => e.Start_Date == Start_Time));
     }
 }
Пример #3
0
 public Deal Get_End_Date(DateTime End_Date)
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Deals.FirstOrDefault(e => e.End_Date == End_Date));
     }
 }
Пример #4
0
 public Deal Get_Description(string Description)
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Deals.FirstOrDefault(e => e.Description == Description));
     }
 }
Пример #5
0
 public Deal Get_Deal_ID(int Deal_ID)
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Deals.FirstOrDefault(e => e.Deal_ID == Deal_ID));
     }
 }
Пример #6
0
 public IEnumerable <Deal> Get()
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Deals.ToList());
     }
 }
Пример #7
0
 public Employee Get_User_ID(int User_ID)
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Employees.FirstOrDefault(e => e.User_ID == User_ID));
     }
 }
Пример #8
0
 public IEnumerable <Employee> Get()
 {
     using (ReServeDBEntities entities = new ReServeDBEntities())
     {
         return(entities.Employees.ToList());
     }
 }