public static List <activityTime> GetActivityTimesByDay(int serviceId, int day) { using (onLineEntities1 entities = new onLineEntities1()) { return(entities.activityTimes.Where(a => a.serviceId == serviceId && a.dayInWeek == day && a.endDate == null).ToList()); } }
public static activityTime GetActivityTimeById(int activityTimeId) { using (onLineEntities1 entities = new onLineEntities1()) { return(entities.activityTimes.FirstOrDefault(a => a.activityTimeId == activityTimeId)); } }
public static int GetNumOfCustomers() { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.customers.Count()); } }
public static int GetNumOfTurnsByBusiness(int businessId) { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.customersInLines.Include(a => a.activityTime).Include(a => a.activityTime.service).Where(c => c.activityTime.service.businessId == businessId).Count()); } }
public static int GetNumOfBusinesses() { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.businesses.Count()); } }
public static List <activityTime> GetActivityTimes(int serviceId) { using (onLineEntities1 entities = new onLineEntities1()) { return(entities.activityTimes.Where(a => a.serviceId == serviceId).ToList()); } }
public static int GetNumOfCategories() { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.categories.Count()); } }
public static List <unusual> GetUnusuals(int serviceId) { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.unusuals.Where(u => u.activityTime.serviceId == serviceId).ToList()); } }
public static List <customersInLine> GetTurnToCust(int custId) { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.customersInLines.Include(a => a.activityTime).Include(a => a.activityTime.service).Include("activityTime.service.business").Where(t => t.custId == custId && (t.actualHour == new TimeSpan() || t.actualHour == null)).ToList()); } //x => x.Quotes.Select(q => q.QuoteItems) }
public static int AddBusiness(business business) { using (onLineEntities1 entities1 = new onLineEntities1()) { entities1.businesses.Add(business); entities1.SaveChanges(); int id = business.businessId; return(id); } }
public static List <customersInLine> GetAllCustomersInTurn() { try { using (onLineEntities1 entities = new onLineEntities1()) { return(entities.customersInLines.Include("customer").Where(t => t.isActive == true && t.preAlert > 0).ToList()); } } catch (Exception) { throw; } }
public static business GetBusinessById(int id) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.businesses.Include("services").FirstOrDefault(b => b.businessId == id)); } } catch (Exception) { throw; } }
public static customersInLine GetTurnByTurnId(int turnId) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.customersInLines.Include("activityTime").First(t => t.TurnId == turnId)); } } catch { throw; } }
public static List <category> GetCategories() { try { using (onLineEntities1 entities = new onLineEntities1()) { return(entities.categories.ToList()); } } catch { throw; } }
public static List <business> GetBusinesses() { try { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.businesses.Include("services").ToList()); } } catch (Exception) { throw; } }
public static List <customersInLine> GetLineByCustomer(int custId) { try { using (onLineEntities1 entities = new onLineEntities1()) { return(entities.customersInLines.Where(a => a.isActive == true && a.custId == custId && a.actualHour == null).ToList()); } } catch (Exception) { throw; } }
public static List <service> GetServicesByBussiness(int businessId) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.services.Include("activityTimes").Where(s => s.businessId == businessId).ToList()); } } catch (Exception) { throw; } }
public static List <customersInLine> GetLinePerActivityTime(int activityTimeId) { try { using (onLineEntities1 entities = new onLineEntities1()) { var q = entities.customersInLines.Include("activityTime").ToList(); return(q.Where(a => a.isActive == true && a.activityTimeId == activityTimeId && (a.actualHour == new TimeSpan() || a.actualHour == null)).OrderBy(l => l.estimatedHour).ToList()); } } catch (Exception) { throw; } }
public static void DeleteTurn(int turnId) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { entities1.customersInLines.Remove(entities1.customersInLines.FirstOrDefault(t => t.TurnId == turnId)); entities1.SaveChanges(); } } catch (Exception) { throw; } }
public static void AddUnUsual(unusual unusual) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { entities1.unusuals.Add(unusual); entities1.SaveChanges(); } } catch (Exception) { throw; } }
public static void AddCustomer(customer customer) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { entities1.customers.Add(customer); entities1.SaveChanges(); } } catch (Exception) { throw; } }
public static service GetServiceById(int serviceId) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { var a = entities1.services.Include("business").ToList(); var b = a.FirstOrDefault(s => s.serviceId == serviceId); return(b); } } catch (Exception) { throw; } }
public static int AddAppointment(customersInLine turn) { try { using (onLineEntities1 entities = new onLineEntities1()) { entities.customersInLines.Add(turn); entities.SaveChanges(); return(turn.TurnId); } } catch (Exception) { throw; } }
public static int GetCustId(string phone) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { return(entities1.customers.FirstOrDefault(c => c.phoneNumber == phone).custId); } } catch (NullReferenceException) { throw new NullReferenceException("משתמש לא קיים"); } catch { throw; } }
public static void UpdateActivityTime(activityTime activityTime) { try { using (onLineEntities1 entities = new onLineEntities1()) { var updateActivityTime = entities.activityTimes.FirstOrDefault(a => a.activityTimeId == activityTime.activityTimeId); updateActivityTime.avgServiceDuration = activityTime.avgServiceDuration.Value; //todo: updateActivityTime.StandardDeviation = activityTime.StandardDeviation.Value; updateActivityTime.sampleSize = updateActivityTime.sampleSize.Value; entities.SaveChanges(); } } catch (Exception) { throw; } }
public static business GetBusinessByPassword(string password) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { business business = entities1.businesses.Include("services").FirstOrDefault(b => b.password == password); if (business == null) { throw new Exception("worng password"); } return(business); } } catch (Exception) { throw; } }
public static void UpdateTurns(List <customersInLine> line) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { for (int i = 0; i < line.Count(); i++) { customersInLine turn = entities1.customersInLines.FirstOrDefault(l => l.TurnId == line[i].TurnId); turn.estimatedHour = line[i].estimatedHour; turn.isActive = line[i].isActive; } entities1.SaveChanges(); } } catch (Exception) { throw; } }
public static void UpdateTurn(customersInLine turnToUpdate) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { customersInLine turn = entities1.customersInLines.FirstOrDefault(l => l.TurnId == turnToUpdate.TurnId); turn.preAlert = turnToUpdate.preAlert; turn.statusTurn = turnToUpdate.statusTurn; turn.verificationCode = turnToUpdate.verificationCode; turn.actualHour = turnToUpdate.actualHour; turn.exitHour = turnToUpdate.exitHour; // entities1.Entry(turnToUpdate).State = EntityState.Modified; entities1.SaveChanges(); } } catch (Exception) { throw; } }