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