public ActionResult Detail(long MstFuelOdometerId) { var data = _fuelodometerBLL.GetByID(MstFuelOdometerId); var model = new FuelOdometerItem(); model = Mapper.Map <FuelOdometerItem>(data); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; return(View(model)); }
public JsonResult UploadFile(HttpPostedFileBase upload) { var qtyPacked = string.Empty; var qty = string.Empty; var data = (new ExcelReader()).ReadExcel(upload); var model = new List <FuelOdometerItem>(); if (data != null) { foreach (var dataRow in data.DataRows) { if (dataRow[0] == "") { continue; } var item = new FuelOdometerItem(); item.ErrorMessage = ""; try { item.VehicleType = dataRow[0].ToString(); item.PoliceNumber = dataRow[1].ToString(); item.EmployeeId = dataRow[2].ToString(); item.EmployeeName = dataRow[3].ToString(); item.EcsRmbTransId = Convert.ToInt32(dataRow[4]); item.SeqNumber = Convert.ToInt32(dataRow[5]); item.ClaimType = dataRow[6].ToString(); item.DateOfCost = Convert.ToDateTime(dataRow[7].ToString()); item.CostCenter = dataRow[8].ToString(); item.LastKM = Convert.ToInt32(dataRow[9]); item.Cost = Convert.ToInt32(dataRow[10]); item.ClaimComment = dataRow[12].ToString(); item.PostedTime = DateTime.Now; item.IsActive = dataRow[13].ToString() == "Active" ? true : false; item.ErrorMessage = string.Empty; //var exist = _fuelodometerBLL.GetFuelOdometer().Where(x => x.SettingGroup.ToUpper() == item.SettingGroup.ToUpper() // && x.SettingName.ToUpper() == item.SettingName.ToUpper() // && x.SettingValue.ToUpper() == item.SettingValue.ToUpper() // && x.IsActive).FirstOrDefault(); if (string.IsNullOrEmpty(dataRow[0].ToString())) { item.ErrorMessage += "Setting Group empty,"; } if (string.IsNullOrEmpty(dataRow[1].ToString())) { item.ErrorMessage += "Setting Name empty,"; } if (string.IsNullOrEmpty(dataRow[2].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[3].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[4].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[5].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[6].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[7].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[8].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[9].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[10].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[11].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[12].ToString())) { item.ErrorMessage += "Setting Value empty,"; } if (string.IsNullOrEmpty(dataRow[13].ToString())) { item.ErrorMessage += "Setting Value empty,"; } // if (exist != null) { item.ErrorMessage += "Data Already Exist,"; } model.Add(item); } catch (Exception ex) { item.ErrorMessage = ex.Message; } } } return(Json(model)); }