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