public static async Task <List <Models.Address.Country> > Get() { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Countries.ToListAsync()); } }
public static async Task <Models.Visual> GetVisual(int visualId) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Visuals.FirstOrDefaultAsync(q => q.Id == visualId)); } }
public static async Task <List <Models.Reservations.Reservation> > GetByStatus(Guid token, string departmentCode, int statusId) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Reservations.Where(q => !q.IsDeleted && q.DepartmentCode == departmentCode && q.ReservationStatus == statusId).ToListAsync()); } }
public static async Task<List<Models.Users.User>> Get(string departmentCode) { using (var db = new DataAccess.CaraxEntitiy()) { return await db.Users.Where(q => q.DepartmentCode == departmentCode && q.IsActive && !q.IsDeleted).Select(q => new Models.Users.User { IsActive = q.IsActive, DepartmentCode = q.DepartmentCode, IsDeleted = q.IsDeleted, CompanyCode = q.CompanyCode, CreatedBy = q.CreatedBy, CreatedDateTime = q.CreatedDateTime, EMail = q.EMail, Id = q.Id, Name = q.Name, Surname = q.Surname, UpdatedBy = q.UpdatedBy, UpdatedDateTime = q.UpdatedDateTime, UserLevel = q.UserLevel, Username = q.Username, VisualId = q.VisualId }) .ToListAsync(); } }
public static async Task <List <Models.Cars.CarService> > Get(Guid token, string departmentCode) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.CarServices?.Where(q => q.DepartmentCode == departmentCode)?.ToListAsync()); } }
public static Models.Users.User Get(int userId) { using (var db = new DataAccess.CaraxEntitiy()) { return db.Users.Where(q => q.IsActive && !q.IsDeleted && q.Id == userId).Select(q => new Models.Users.User { IsActive = q.IsActive, DepartmentCode = q.DepartmentCode, IsDeleted = q.IsDeleted, CompanyCode = q.CompanyCode, CreatedBy = q.CreatedBy, CreatedDateTime = q.CreatedDateTime, EMail = q.EMail, Id = q.Id, Name = q.Name, Surname = q.Surname, UpdatedBy = q.UpdatedBy, UpdatedDateTime = q.UpdatedDateTime, UserLevel = q.UserLevel, Username = q.Username, VisualId = q.VisualId }).FirstOrDefault(); } }
private static async Task <bool> CheckCurrentCustomers(Models.Customers.Customer customer) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Customers.AnyAsync(q => q.Tc == customer.Tc || q.FirstPhone == customer.FirstPhone)); } }
public static async Task <List <Models.Cars.BrandModel> > GetModelByBrandId(int brandId) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.BrandModels.Where(q => q.BrandId == brandId && !q.IsDeleted).ToListAsync()); } }
public static async Task <List <Models.Cars.Brand> > GetBrand() { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Brands.Where(q => !q.IsDeleted).ToListAsync()); } }
public static async Task <List <Models.Cars.CarProperty> > Get(Guid token, int carId) { AuthenticationLogic.CheckTokenInfo(token); using (var db = new DataAccess.CaraxEntitiy()) { return(await db.CarProperties?.Where(q => q.CarId == carId)?.ToListAsync()); } }
public static async Task <Models.Customers.Customer> GetByCustomerTc(Guid token, string departmentCode, string tc) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Customers .FirstOrDefaultAsync(q => q.DepartmentCode == departmentCode && q.Tc == tc)); } }
public static async Task <List <Models.Customers.Customer> > GetList(Guid token, string departmentCode, bool isActive = true) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Customers ?.Where(q => q.IsActive == isActive && q.DepartmentCode == departmentCode && !q.IsDeleted) ?.ToListAsync()); } }
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 <List <Models.Cars.CarService> > Get(Guid token, string departmentCode, int carId) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.CarInServices. Include(q => q.CarService). Where(q => q.CarId == carId && q.CarService.DepartmentCode == departmentCode)?. Select(a => a.CarService)?. ToListAsync()); } }
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> CheckAccessToken(string accessToken, string departmentCode) { var validToken = Guid.TryParse(accessToken, out Guid result); if (!validToken) { return(false); } using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Departments.AnyAsync(q => q.AccessToken.Value == result && q.Code == departmentCode)); } }
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 <List <Models.Reservations.ReservationsCarsCustomer> > GetList(string departmentCode, bool isApproval = false) { try { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Reservations. Include(a => a.Car). Include(a => a.Car.Brand). Include(a => a.Car.BrandModel). Include(a => a.Customer). Where(q => !q.IsDeleted && q.DepartmentCode == departmentCode && q.IsApproval == isApproval) .Select(a => new ReservationsCarsCustomer { ReservationStartDateTime = a.BeginDateTime, ReservationEndDateTime = a.EndDateTime, ReservationPrice = a.Price, ReservationId = a.Id, CarBrandName = a.Car.Brand.Name, CarEngineCapacity = a.Car.EngineCapacity, CarId = a.CarId, CarModelName = a.Car.BrandModel.Name, CarPlate = a.Car.Plate, CarPrice = a.Car.Price, CustomerFirstPhone = a.Customer.FirstPhone, CustomerId = a.CustomerId, CustomerName = a.Customer.Name, CustomerSurname = a.Customer.Surname, ReservationState = a.ReservationStatus, CreatedDateTime = a.CreatedDateTime, CreatedBy = a.CreatedBy, ReservationDeposit = a.Deposit, ReservationFuelCount = a.FuelCount, ReservationKmEnd = a.KmEnd, ReservationKmStart = a.KmStart, ReservationPaymentType = a.PaymentType, LocationSite = a.LocationSite }). OrderByDescending(q => q.CreatedDateTime). ToListAsync()); } } catch (Exception e) { Console.WriteLine(e); throw; } }
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 <List <Models.Cars.Car> > GetList(Guid token, string departmentCode, bool isMaintenance = false) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Cars.Include(a => a.Brand) .Include(a => a.BrandModel) ?.Where(q => !q.IsDeleted && q.DepartmentCode == departmentCode && q.Maintenance == isMaintenance && !q.IsDeleted). Select(a => new Models.Cars.Car { DepartmentCode = a.DepartmentCode, Id = a.Id, Name = a.Name, BrandId = a.BrandId, BrandModelId = a.BrandModelId, BrandName = a.Brand.Name, ModelName = a.BrandModel.Name, CaseType = a.CaseType, Classes = a.Classes, Color = a.Color, CompanyCode = a.CompanyCode, Crash = a.Crash, CreatedBy = a.CreatedBy, CreatedDateTime = a.CreatedDateTime, Deposit = a.Deposit, EngineCapacity = a.EngineCapacity, FuelType = a.FuelType, GearType = a.GearType, IsDeleted = a.IsDeleted, Km = a.Km, Maintenance = a.Maintenance, MinDriverLicense = a.MinDriverLicense, NumberOfDoors = a.NumberOfDoors, Plate = a.Plate, Price = a.Price, VisualId = a.BrandModel.VisualId, UpdatedBy = a.UpdatedBy, UpdatedDateTime = a.UpdatedDateTime, Year = a.Year, }) ?.ToListAsync()); } }
public static Models.Cars.Car GetSingleCar(Guid token, string departmentCode, int carId) { using (var db = new DataAccess.CaraxEntitiy()) { return(db.Cars.Include(a => a.Brand) .Include(a => a.BrandModel) ?.Where(q => !q.IsDeleted && q.DepartmentCode == departmentCode && q.Id == carId && !q.IsDeleted). Select(a => new Models.Cars.Car { DepartmentCode = a.DepartmentCode, Id = a.Id, Name = a.Name, BrandId = a.BrandId, BrandModelId = a.BrandModelId, BrandName = a.Brand.Name, ModelName = a.BrandModel.Name, CaseType = a.CaseType, Classes = a.Classes, Color = a.Color, CompanyCode = a.CompanyCode, Crash = a.Crash, CreatedBy = a.CreatedBy, CreatedDateTime = a.CreatedDateTime, Deposit = a.Deposit, EngineCapacity = a.EngineCapacity, FuelType = a.FuelType, GearType = a.GearType, IsDeleted = a.IsDeleted, Km = a.Km, Maintenance = a.Maintenance, MinDriverLicense = a.MinDriverLicense, NumberOfDoors = a.NumberOfDoors, Plate = a.Plate, Price = a.Price, VisualId = a.BrandModel.VisualId, UpdatedBy = a.UpdatedBy, UpdatedDateTime = a.UpdatedDateTime, Year = a.Year }) ?.FirstOrDefault()); } }
public static async Task <IList <Models.Cars.Car> > AvailableCar(string departmentCode, DateTime beginDate, DateTime endDate) { using (var db = new DataAccess.CaraxEntitiy()) { return(await db.Cars.Include(q => q.Reservations) .Where(q => q.DepartmentCode == departmentCode && !q.IsDeleted && !q.Crash && !q.Maintenance && !q.Reservations. Any(a => ((a.BeginDateTime <= beginDate && a.EndDateTime >= beginDate) || (a.BeginDateTime <= endDate && a.EndDateTime >= endDate)) || beginDate <= a.BeginDateTime && endDate >= a.EndDateTime)) .Select(a => new Models.Cars.Car { DepartmentCode = a.DepartmentCode, Id = a.Id, Name = a.Name, BrandId = a.BrandId, BrandModelId = a.BrandModelId, BrandName = a.Brand.Name, ModelName = a.BrandModel.Name, CaseType = a.CaseType, Classes = a.Classes, Color = a.Color, CompanyCode = a.CompanyCode, Crash = a.Crash, CreatedBy = a.CreatedBy, CreatedDateTime = a.CreatedDateTime, Deposit = a.Deposit, EngineCapacity = a.EngineCapacity, FuelType = a.FuelType, GearType = a.GearType, IsDeleted = a.IsDeleted, Km = a.Km, Maintenance = a.Maintenance, MinDriverLicense = a.MinDriverLicense, NumberOfDoors = a.NumberOfDoors, Plate = a.Plate, Price = a.Price, VisualId = a.BrandModel.VisualId, UpdatedBy = a.UpdatedBy, UpdatedDateTime = a.UpdatedDateTime, Year = a.Year }) .ToListAsync()); } }