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