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