public ActionResult Create()
{
var model = new GsItem();
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
model = InitialModel(model);
return(View(model));
}
public ActionResult Create(GsItem model)
{
if (ModelState.IsValid)
{
try
{
var exist = _gsBLL.GetGs().Where(x => (x.PoliceNumber == null ? "" : x.PoliceNumber.ToUpper()) == (model.PoliceNumber == null ? "" : model.PoliceNumber.ToUpper()) &&
x.EmployeeId == model.EmployeeId && (x.Remark == null ? "" : x.Remark.ToUpper()) == (model.Remark == null ? "" : model.Remark.ToUpper()) &&
(x.EmployeeName == null ? "" : x.EmployeeName.ToUpper()) == (model.EmployeeName == null ? "" : model.EmployeeName.ToUpper()) && x.GsRequestDate == model.GsRequestDate && x.StartDate == model.StartDate &&
(x.VehicleUsage == null ? "" : x.VehicleUsage.ToUpper()) == (model.VehicleUsage == null ? "" : model.VehicleUsage.ToUpper()) && x.GsFullfillmentDate == model.GsFullfillmentDate && x.EndDate == model.EndDate &&
(x.Manufacturer == null ? "" : x.Manufacturer.ToUpper()) == (model.Manufacturer == null ? "" : model.Manufacturer.ToUpper()) && (x.GsManufacturer == null ? "" : x.GsManufacturer.ToUpper()) == (model.GsManufacturer == null ? "" : model.GsManufacturer.ToUpper()) &&
(x.Model == null ? "" : x.Model.ToUpper()) == (model.Models == null ? "" : model.Models.ToUpper()) && (x.GsModel == null ? "" : x.GsModel.ToUpper()) == (model.GsModel == null ? "" : model.GsModel.ToUpper()) &&
(x.Series == null ? "" : x.Series.ToUpper()) == (model.Series == null ? "" : model.Series.ToUpper()) && (x.GsSeries == null ? "" : x.GsSeries.ToUpper()) == (model.GsSeries == null ? "" : model.GsSeries.ToUpper()) &&
(x.Transmission == null ? "" : x.Transmission.ToUpper()) == (model.Transmission == null ? "" : model.Transmission.ToUpper()) && (x.GsTransmission == null ? "" : x.GsTransmission.ToUpper()) == (model.GsTransmission == null ? "" : model.GsTransmission.ToUpper()) &&
(x.Location == null ? "" : x.Location.ToUpper()) == (model.Location == null ? "" : model.Location.ToUpper()) && (x.GsPoliceNumber == null ? "" : x.GsPoliceNumber.ToUpper()) == (model.GsPoliceNumber == null ? "" : model.GsPoliceNumber.ToUpper()) &&
x.GroupLevel == model.GroupLevel && x.IsActive).FirstOrDefault();
if (exist != null)
{
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
model.ErrorMessage = "Data Already exist";
model = InitialModel(model);
return(View(model));
}
var data = Mapper.Map <GsDto>(model);
data.CreatedBy = CurrentUser.USER_ID;
data.CreatedDate = DateTime.Now;
model = InitialModel(model);
data.IsActive = true;
_gsBLL.Save(data);
_gsBLL.SaveChanges();
}
catch (Exception exp)
{
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
model.ErrorMessage = exp.Message;
model = InitialModel(model);
return(View(model));
}
}
return(RedirectToAction("Index", "MstGs"));
}
public GsItem InitialModel(GsItem model)
{
var policeList = _fleetBLL.GetFleet().Where(x => x.IsActive == true).ToList();
model.PoliceNumberList = new SelectList(policeList, "PoliceNumber", "PoliceNumber");
var RemarkList = _remarkBLL.GetRemark().Where(x => x.IsActive == true && x.DocumentType == (int)Enums.DocumentType.GS).ToList();
model.RemarkList = new SelectList(RemarkList, "Remark", "Remark");
var EmployeeList = _employeeBLL.GetEmployee().Where(x => x.IS_ACTIVE == true).Select(x => new { EmployeeName = x.FORMAL_NAME }).ToList();
model.EmployeeList = new SelectList(EmployeeList, "EmployeeName", "EmployeeName");
var LocationList = _locationMappingBLL.GetLocationMapping().Select(x => new { location = x.Location }).ToList();
model.LocationList = new SelectList(LocationList, "location", "location");
return(model);
}
public JsonResult UploadFile(HttpPostedFileBase upload)
{
var data = (new ExcelReader()).ReadExcel(upload);
var model = new List <GsItem>();
if (data != null)
{
foreach (var dataRow in data.DataRows)
{
if (dataRow[0] == "")
{
continue;
}
var item = new GsItem();
item.ErrorMessage = "";
try
{
var GsFullfillmentDateD = dataRow[11].ToString() == null ? 0 : double.Parse(dataRow[11].ToString());
item.GsFullfillmentDate = DateTime.FromOADate(GsFullfillmentDateD);
}
catch (Exception)
{
item.ErrorMessage = "Gs Fullfillment Date is not valid Format";
}
try
{
var GsRequestDateD = dataRow[10].ToString() == null ? 0 : double.Parse(dataRow[10].ToString());
item.GsRequestDate = DateTime.FromOADate(GsRequestDateD);
}
catch (Exception)
{
item.ErrorMessage = "Gs Request Date is not valid Format";
}
try
{
var StartDateD = dataRow[17].ToString() == null ? 0 : double.Parse(dataRow[17].ToString());
item.StartDate = DateTime.FromOADate(StartDateD);
}
catch (Exception)
{
item.ErrorMessage = "Start Date is not valid Format";
}
try
{
var EndDateD = dataRow[18].ToString() == null ? 0 : double.Parse(dataRow[18].ToString());
item.EndDate = DateTime.FromOADate(EndDateD);
}
catch (Exception)
{
item.ErrorMessage = "End Date is not valid Format";
}
item.PoliceNumber = dataRow[3].ToString();
if (item.PoliceNumber == "")
{
item.ErrorMessage = "Police Number must be filled";
}
else
{
var PoliceNumber = _fleetBLL.GetFleet().Where(x => (x.PoliceNumber == null ? "" : x.PoliceNumber.ToUpper()) == (item.PoliceNumber == null ? "" : item.PoliceNumber.ToUpper()) &&
x.IsActive).FirstOrDefault();
if (PoliceNumber == null)
{
item.ErrorMessage = "there is no active Police Number In Master fleet with this Police Number";
}
}
item.GsManufacturer = dataRow[12].ToString();
if (item.GsManufacturer == "")
{
item.ErrorMessage = "GS Manufaturer can't be Empty";
}
item.GsModel = dataRow[13].ToString();
if (item.GsModel == "")
{
item.ErrorMessage = "GS Model can't be Empty";
}
item.GsSeries = dataRow[14].ToString();
if (item.GsSeries == "")
{
item.ErrorMessage = "GS Series can't be Empty";
}
item.GsTransmission = dataRow[15].ToString();
if (item.GsTransmission == "")
{
item.ErrorMessage = "GS Transmission can't be Empty";
}
item.GsPoliceNumber = dataRow[16].ToString();
if (item.GsPoliceNumber == "")
{
item.ErrorMessage = "GS Police Number can't be Empty";
}
item.Remark = dataRow[20].ToString();
if (item.Remark == "")
{
item.ErrorMessage = "Remark Can't be empty";
}
else
{
var Remark = _remarkBLL.GetRemark().Where(x => x.IsActive == true && x.DocumentType == (int)Enums.DocumentType.GS).FirstOrDefault();
if (Remark == null)
{
item.ErrorMessage = "Remark is not in the Master Remark";
}
}
model.Add(item);
}
}
return(Json(model));
}
