public ActionResult Upload() { var model = new FuelOdometerModel(); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; return(View(model)); }
public ActionResult Upload(FuelOdometerModel Model) { if (ModelState.IsValid) { foreach (var data in Model.Details) { try { data.CreatedDate = DateTime.Now; data.CreatedBy = CurrentUser.USERNAME; data.IsActive = true; if (data.ErrorMessage == "" | data.ErrorMessage == null) { //var Exist = _fuelodometerBLL.GetFuelOdometer().Where(x => (x.VehicleType == null ? "" : x.VehicleType.ToUpper()) == (data.VehicleType == null ? "" : data.VehicleType.ToUpper()) // && (x.RoleType == null ? "" : x.RoleType.ToUpper()) == (data.RoleType == null ? "" : data.RoleType.ToUpper()) // && x.IsActive).FirstOrDefault(); var Exist = _fuelodometerBLL.GetFuelOdometer().Where(x => x.VehicleType == data.VehicleType && x.PoliceNumber == data.PoliceNumber && x.EmployeeId == data.EmployeeId && x.EcsRmbTransId == data.EcsRmbTransId && x.SeqNumber == data.SeqNumber && x.DateOfCost == data.DateOfCost && x.CostCenter == data.CostCenter && x.IsActive == true).FirstOrDefault(); if (Exist != null) { Exist.IsActive = false; Exist.ModifiedBy = "SYSTEM"; Exist.ModifiedDate = DateTime.Now; _fuelodometerBLL.Save(Exist, CurrentUser); } var dto = Mapper.Map <FuelOdometerDto>(data); _fuelodometerBLL.Save(dto, CurrentUser); } AddMessageInfo(Constans.SubmitMessage.Saved, Enums.MessageInfoType.Success); } catch (Exception exception) { AddMessageInfo(exception.Message, Enums.MessageInfoType.Error); Model.CurrentLogin = CurrentUser; return(View(Model)); } } _fuelodometerBLL.SaveChanges(); } return(RedirectToAction("Index", "MstFuelOdometer")); }
// // GET: /MstFuelOdometer/ public ActionResult Index() { var model = new FuelOdometerModel(); //model.Details = Mapper.Map<List<FuelOdometerItem>>(data); model.SearchView = new FuelOdometerSearchView(); var fleetList = _fleetBLL.GetFleet().ToList(); var costCenterList = _groupCostCenterBLL.GetGroupCenter().ToList(); var fuelOdometerList = _fuelodometerBLL.GetFuelOdometer().ToList(); var listVehType = _settingBLL.GetSetting().Where(x => x.SettingGroup == EnumHelper.GetDescription(Enums.SettingGroup.VehicleType) && x.IsActive).Select(x => new { x.MstSettingId, x.SettingValue }).ToList(); model.SearchView.PoliceNumberList = new SelectList(fleetList.Select(x => new { x.PoliceNumber }).Distinct().ToList(), "PoliceNumber", "PoliceNumber"); model.SearchView.EmployeeNameList = new SelectList(fleetList.Select(x => new { x.EmployeeName }).Distinct().ToList(), "EmployeeName", "EmployeeName"); model.SearchView.EmployeeIDList = new SelectList(fleetList.Select(x => new { x.EmployeeID }).Distinct().ToList(), "EmployeeID", "EmployeeID"); model.SearchView.CostCenterList = new SelectList(costCenterList.Select(x => new { x.CostCenter }).Distinct().ToList(), "CostCenter", "CostCenter"); model.SearchView.EcsRmbTransIdList = new SelectList(fuelOdometerList.Select(x => new { x.EcsRmbTransId }).Distinct().ToList(), "EcsRmbTransId", "EcsRmbTransId"); model.SearchView.ClaimTypeList = new SelectList(fuelOdometerList.Select(x => new { x.ClaimType }).Distinct().ToList(), "ClaimType", "ClaimType"); model.SearchView.VehicleTypeList = new SelectList(listVehType.Select(x => new { x.SettingValue }).Distinct().ToList(), "SettingValue", "SettingValue"); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; model.CurrentPageAccess = CurrentPageAccess; return(View(model)); }