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;
}
}
