public WorkingPoint AddWorkingPoint(WorkingPoint WorkingPoint)
{
VehicleServiceCompany CurrentService = ServiceBookContext.VehicleServiceCompany.FirstOrDefault(x => x.ID == WorkingPoint.VSCID);
WorkingPoint workingpoint = ServiceBookContext.WorkingPoint.FirstOrDefault(x => x.City == WorkingPoint.City && x.Country == WorkingPoint.Country && x.Street == WorkingPoint.Street && x.Nr == WorkingPoint.Nr);
if (workingpoint != null)
{
if (workingpoint.Flag == 0)
{
return(null);
}
else
{
workingpoint.VehicleServiceCompany = CurrentService;
workingpoint.Flag = 0;
ServiceBookContext.SaveChanges();
WorkingPoint = workingpoint;
}
}
else
{
WorkingPoint.VehicleServiceCompany = CurrentService;
WorkingPoint.Flag = 0;
ServiceBookContext.WorkingPoint.Add(WorkingPoint);
ServiceBookContext.SaveChanges();
}
return(WorkingPoint);
}
public int EditServiceCompany(VehicleServiceCompany VehicleServiceCompany)
{
VehicleServiceCompany vehicleServiceCompany = ServiceBookContext.VehicleServiceCompany.FirstOrDefault(x => x.ServiceName == VehicleServiceCompany.ServiceName);
if (vehicleServiceCompany == null)
{
vehicleServiceCompany = ServiceBookContext.VehicleServiceCompany.FirstOrDefault(x => x.ID == VehicleServiceCompany.ID);
vehicleServiceCompany.ServiceName = VehicleServiceCompany.ServiceName;
ServiceBookContext.SaveChanges();
return(1);
}
return(0);
}
public void DeletVehicleServiceCompany(string uid, VehicleServiceCompany VehicleServiceCompany)
{
VehicleServiceCompanyOwner CurrentOwner = ServiceBookContext.VehicleServiceCompanyOwner.FirstOrDefault(x => x.UID == uid);
CCO deletVehicleServiceCompany = ServiceBookContext.CCO.FirstOrDefault(x => x.COID == CurrentOwner.ID && x.CID == VehicleServiceCompany.ID);
if (deletVehicleServiceCompany.VehicleServiceCompany != null)
{
if (deletVehicleServiceCompany.VehicleServiceCompany.WorkingPoints != null)
{
foreach (var workingPoint in deletVehicleServiceCompany.VehicleServiceCompany.WorkingPoints)
{
WorkingPointRepository.DeletWorkingPoint(workingPoint);
}
}
}
ServiceBookContext.CCO.Remove(deletVehicleServiceCompany);
ServiceBookContext.SaveChanges();
}
public CCO AddVehicleServiceCompany(string uid, VehicleServiceCompany VehicleServiceCompany)
{
VehicleServiceCompanyOwner CurrentOwner = ServiceBookContext.VehicleServiceCompanyOwner.FirstOrDefault(x => x.UID == uid);
VehicleServiceCompany Company = ServiceBookContext.VehicleServiceCompany.FirstOrDefault(x => x.ServiceName == VehicleServiceCompany.ServiceName);
var CCO = ServiceBookContext.CCO.FirstOrDefault(x => x.VehicleServiceCompanyOwner.ID == CurrentOwner.ID && x.VehicleServiceCompany.ServiceName == VehicleServiceCompany.ServiceName);
CCO cco = new CCO();
if (CCO == null)
{
cco.VehicleServiceCompanyOwner = CurrentOwner;
if (Company != null)
{
cco.VehicleServiceCompany = Company;
}
else
{
cco.VehicleServiceCompany = VehicleServiceCompany;
}
cco.VehicleServiceCompany.Flag = 0;
ServiceBookContext.CCO.Add(cco);
ServiceBookContext.SaveChanges();
}
else
{
if (CCO.VehicleServiceCompany.Flag == 0)
{
return(null);
}
CCO.VehicleServiceCompany.Flag = 0;
ServiceBookContext.SaveChanges();
cco = CCO;
}
return(cco);
}
