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