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 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 AddCustomer(customer customer) { try { using (onLineEntities1 entities1 = new onLineEntities1()) { entities1.customers.Add(customer); 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 int AddAppointment(customersInLine turn) { try { using (onLineEntities1 entities = new onLineEntities1()) { entities.customersInLines.Add(turn); entities.SaveChanges(); return(turn.TurnId); } } catch (Exception) { 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 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; } }