public void Edit(TruckModel truckModel)
{
try
{
Common.DAL.Truck truck = dbContext.Trucks.Where(x => x.Id == truckModel.Id).FirstOrDefault();
if (truck == null)
{
base.HandleError(truckModel, CommonLayer.LookUps.ErrorType.Critical, null, Resources.NotFound);
return;
}
if (Validate(truckModel))
{
return;
}
TruckMapper.Map(dbContext, truckModel, truck);
base.SaveChanges();
truckModel.AddSuccess(Resources.TruckUpdatedSuccessfully, LookUps.SuccessType.Full);
}
catch (Exception ex)
{
base.HandleError(truckModel, CommonLayer.LookUps.ErrorType.Exception, ex);
base.UndoUpdates();
}
}
public async void AddTruck(Truck truck)
{
var mapper = new TruckMapper();
var newTruck = mapper.MapToServiceModel(truck);
await client.AddTruckAsync(newTruck);
}
public async void UpdateTruck(Truck truck)
{
TruckMapper mapper = new TruckMapper();
var uptadeTruck = mapper.MapToServiceModel(truck);
await client.UpdateTruckAsync(uptadeTruck);
client.Close();
}
public void GetTruckModel(TruckModel truckModel)
{
try
{
Common.DAL.Truck truck = dbContext.Trucks.Where(x => x.Id == truckModel.Id).FirstOrDefault();
if (truck == null)
{
base.HandleError(truckModel, CommonLayer.LookUps.ErrorType.Critical, null, Resources.NotFound);
}
else
{
TruckMapper.Map(dbContext, truck, truckModel);
}
}
catch (Exception ex)
{
base.HandleError(truckModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
}
public void Create(TruckModel truckModel)
{
try
{
if (Validate(truckModel))
{
return;
}
using (var transaction = dbContext.Database.BeginTransaction())
{
try
{
Common.DAL.Truck truck = new Common.DAL.Truck();
TruckMapper.Map(dbContext, truckModel, truck);
truck.Id = Guid.NewGuid().ToString();
dbContext.Trucks.Add(truck);
base.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
truckModel.AddSuccess(Resources.TruckAddedSuccessfully, LookUps.SuccessType.Full);
}
}
catch (Exception ex)
{
base.HandleError(truckModel, CommonLayer.LookUps.ErrorType.Exception, ex);
base.UndoUpdates();
}
}
public GenericListModel <TruckModel> GetTrucks(Select2Parameters <bool> select2Parameters)
{
GenericListModel <TruckModel> baseListModel = new GenericListModel <TruckModel>();
try
{
IQueryable <Common.DAL.Truck> trucks = prepareSearch(select2Parameters.text);
trucks = trucks.OrderBy(x => x.CreatedAt);
baseListModel.Total = trucks.Count();
trucks = trucks.Skip(select2Parameters.start);
trucks = trucks.Take(select2Parameters.pageSize);
TruckMapper.Map(dbContext, trucks.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
public GenericListModel <TruckModel> GetSearchTrucksList(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <TruckModel> baseListModel = new GenericListModel <TruckModel>();
try
{
IQueryable <Common.DAL.Truck> trucks = prepareSearch(dataTableSearchParameters.search.value);
foreach (JQDTColumnOrder order in dataTableSearchParameters.order)
{
switch (order.column)
{
case 0:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.Name);
}
else
{
trucks = trucks.OrderByDescending(c => c.Name);
}
break;
case 1:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.OnBuyPrice);
}
else
{
trucks = trucks.OrderByDescending(c => c.OnBuyPrice);
}
break;
case 2:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.OnBuyMilage);
}
else
{
trucks = trucks.OrderByDescending(c => c.OnBuyMilage);
}
break;
case 3:
if (order.dir == JQDTColumnOrderDirection.asc)
{
trucks = trucks.OrderBy(c => c.DriverId == null ? "" : c.Driver.Name);
}
else
{
trucks = trucks.OrderByDescending(c => c.DriverId == null ? "" : c.Driver.Name);
}
break;
}
}
baseListModel.Total = trucks.Count();
trucks = trucks.Skip(dataTableSearchParameters.start);
if (dataTableSearchParameters.length != -1)
{
trucks = trucks.Take(dataTableSearchParameters.length);
}
TruckMapper.Map(dbContext, trucks.ToList(), baseListModel.List);
}
catch (Exception ex)
{
base.HandleError(baseListModel, CommonLayer.LookUps.ErrorType.Critical, ex);
}
return(baseListModel);
}
