public static async Task <bool> Remove(Guid token, int customerId)
{
using (var db = new DataAccess.CaraxEntitiy())
{
var find = db.Customers.First(q => q.Id == customerId);
db.Customers.Remove(find);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Create(Guid token, string departmentCode, Models.Cars.CarInService carInService)
{
AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
var find = db.CarInServices.First(q => q.CarId == carInService.CarId && q.CarServiceId == carInService.CarServiceId);
await db.CarInServices.AddAsync(carInService);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Remove(Guid token, string departmentCode, int carId, int serviceId)
{
AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
var find = db.CarInServices.First(q => q.CarId == carId && q.CarServiceId == serviceId);
db.CarInServices.Remove(find);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Delete(Guid token, int propertyId)
{
AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
var finded = db.CarProperties.First(q => q.Id == propertyId);
db.CarProperties.Remove(finded);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Update(Guid token, Models.Cars.CarProperty carProperty)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
carProperty.UpdatedDateTime = DateTime.Now;
carProperty.UpdatedBy = userInfo.Username;
db.CarProperties.Update(carProperty);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Delete(Guid token, string departmentCode, int id)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
var findCarService = db.CarServices.First(q => q.Id == id);
db.CarServices.Remove(findCarService);
return(await db.SaveChangesAsync() > 0);
}
}
// Public Reservation Logic
public static async Task <bool> PublicCreate(Models.Reservations.Reservation reservation, string departmentCode)
{
using (var db = new DataAccess.CaraxEntitiy())
{
reservation.CreatedDateTime = DateTime.Now;
reservation.CreatedBy = departmentCode;
reservation.DepartmentCode = departmentCode;
reservation.CompanyCode = reservation.CompanyCode;
await db.Reservations.AddAsync(reservation);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Update(Guid token, string departmentCode, CarService carService)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
carService.DepartmentCode = departmentCode;
carService.UpdatedDateTime = DateTime.Now;
carService.UpdatedBy = userInfo.Username;
db.CarServices.Update(carService);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Update(Guid token, Models.Reservations.Reservation reservation)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
reservation.UpdatedDateTime = DateTime.Now;
reservation.UpdatedBy = userInfo.Username;
reservation.DepartmentCode = userInfo.DepartmentCode;
reservation.CompanyCode = userInfo.CompanyCode;
db.Reservations.Update(reservation);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Create(Guid token, string departmentCode,
Models.Reservations.ServicesInReservation servicesInReservation)
{
var userinfo = AuthenticationLogic.CheckTokenInfo(token);
servicesInReservation.DepartmentCode = departmentCode;
servicesInReservation.CreatedDateTime = DateTime.Now;
servicesInReservation.CreatedBy = userinfo.Username;
using (var db = new DataAccess.CaraxEntitiy())
{
await db.ServicesInReservations.AddAsync(servicesInReservation);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <int> Create(string departmentCode, Models.Visual visual)
{
using (var db = new DataAccess.CaraxEntitiy())
{
visual.CreatedDateTime = DateTime.Now;
visual.DepartmentCode = departmentCode;
db.Visuals.Add(visual);
if (await db.SaveChangesAsync() > 0)
{
return(visual.Id);
}
return(-1);
}
}
public static async Task <bool> BeCrash(Guid token, int carId, bool crash = false)
{
using (var db = new DataAccess.CaraxEntitiy())
{
var findedCar = db.Cars.FirstOrDefault(q => q.Id == carId);
if (findedCar == null)
{
return(false);
}
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
findedCar.Crash = crash;
findedCar.UpdatedDateTime = DateTime.Now;
findedCar.UpdatedBy = userInfo.Username;
db.Cars.Update(findedCar);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Add(Guid token, Models.Customers.Customer customer)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
customer.CreatedDateTime = DateTime.Now;
customer.CreatedBy = userInfo.Username;
customer.DepartmentCode = userInfo.DepartmentCode;
customer.CompanyCode = userInfo.CompanyCode;
using (var db = new DataAccess.CaraxEntitiy())
{
if (!await CheckCurrentCustomers(customer))
{
await db.Customers.AddAsync(customer);
return(await db.SaveChangesAsync() > 0);
}
return(false);
}
}
public static async Task <bool> Add(Guid token, string departmentCode, Models.Cars.Car car)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
car.CreatedDateTime = DateTime.Now;
car.CreatedBy = userInfo.Username;
car.CompanyCode = userInfo.CompanyCode;
car.DepartmentCode = departmentCode;
using (var db = new DataAccess.CaraxEntitiy())
{
var isExistCar = await db.Cars.AnyAsync(q => q.Plate.ReplaceCarPlate().Contains(car.Plate.ReplaceCarPlate()));
if (isExistCar)
{
return(false);
}
db.Cars.Add(car);
return(await db.SaveChangesAsync() > 0);
}
}
public static async Task <bool> Update(Guid token, Models.Customers.Customer customer)
{
var userInfo = AuthenticationLogic.CheckTokenInfo(token);
using (var db = new DataAccess.CaraxEntitiy())
{
var cs = db.Customers.First(q => q.Id == customer.Id);
cs.Tc = customer.Tc;
cs.Address = customer.Address;
cs.BirthOfDateTime = customer.BirthOfDateTime;
cs.EMail = customer.EMail;
cs.FirstPhone = customer.FirstPhone;
cs.Gender = customer.Gender;
cs.Name = customer.Name;
cs.Nationality = customer.Nationality;
cs.PassportSerialNumber = customer.PassportSerialNumber;
cs.SecondPhone = customer.SecondPhone;
cs.SerialNumberOfDrivingLicense = customer.SerialNumberOfDrivingLicense;
cs.Surname = customer.Surname;
cs.LicenseYear = customer.LicenseYear;
cs.UpdatedDateTime = DateTime.Now;
cs.UpdatedBy = userInfo.Username;
cs.CompanyCode = userInfo.CompanyCode;
cs.DepartmentCode = userInfo.DepartmentCode;
cs.NameOfFather = customer.NameOfFather;
cs.NameOfMother = customer.NameOfMother;
cs.DrivingClasses = customer.DrivingClasses;
cs.BloodGroup = customer.BloodGroup;
cs.Profession = customer.Profession;
cs.CityId = customer.CityId;
cs.CountryCode = customer.CountryCode;
cs.CountyId = customer.CountyId;
cs.IsAdditionalDriver = customer.IsAdditionalDriver;
db.Customers.Update(cs);
return(await db.SaveChangesAsync() > 0);
}
}
// Public Customer Logic
public static async Task <Models.Customers.Customer> Add(Models.Customers.Customer customer, string departmentCode)
{
customer.CreatedDateTime = DateTime.Now;
customer.CreatedBy = departmentCode;
customer.DepartmentCode = departmentCode;
customer.CompanyCode = customer.CompanyCode;
using (var db = new DataAccess.CaraxEntitiy())
{
if (!await CheckCurrentCustomers(customer))
{
await db.Customers.AddAsync(customer);
await db.SaveChangesAsync();
return(customer);
}
var finded = db.Customers.First(q => q.Tc == customer.Tc || q.FirstPhone == customer.FirstPhone);
return(finded);
}
}
