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