public ActionResult Create() { var model = new RemarkItem(); var list1 = _documentTypeBLL.GetDocumentType(); model.DocumentTypeList = new SelectList(list1, "MstDocumentTypeId", "DocumentType"); var list2 = new List <SelectListItem> { new SelectListItem { Text = "HR", Value = "HR" }, new SelectListItem { Text = "Fleet", Value = "Fleet" }, new SelectListItem { Text = "Admin", Value = "Admin" }, }; model.RoleTypeList = new SelectList(list2, "Value", "Text"); 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 <RemarkItem>(); if (data != null) { foreach (var dataRow in data.DataRows) { if (dataRow[0] == "") { continue; } var item = new RemarkItem(); item.ErrorMessage = ""; try { var getdto = _documentTypeBLL.GetDocumentType().Where(x => x.DocumentType == dataRow[0]).FirstOrDefault(); item.MstDocumentType = dataRow[0]; if (getdto == null) { item.ErrorMessage = "Document " + dataRow[0] + " is not in the Master Document Type"; } else if (getdto != null) { item.DocumentType = getdto.MstDocumentTypeId; } item.Remark = dataRow[1].ToString(); if (item.Remark == "") { item.ErrorMessage = "Remark Can't be empty"; } item.RoleType = dataRow[2] == null ? "" : dataRow[2].ToUpper(); if (item.RoleType == "") { item.ErrorMessage = "Role Type Can't be empty"; } model.Add(item); } catch (Exception ex) { item.ErrorMessage = ex.Message; } } } return(Json(model)); }
public ActionResult Create(RemarkItem model) { if (ModelState.IsValid) { try { var Exist = _remarkBLL.GetRemark().Where(x => (x.Remark == null ? "" : x.Remark.ToUpper()) == (model.Remark == null ? "" : model.Remark.ToUpper()) && (x.RoleType == null ? "" : x.RoleType.ToUpper()) == (model.RoleType == null ? "" : model.RoleType.ToUpper()) && x.DocumentType == model.DocumentType && x.IsActive).FirstOrDefault(); if (Exist != null) { var list1 = _documentTypeBLL.GetDocumentType(); model.DocumentTypeList = new SelectList(list1, "MstDocumentTypeId", "DocumentType"); var list2 = new List <SelectListItem> { new SelectListItem { Text = "HR", Value = "HR" }, new SelectListItem { Text = "Fleet", Value = "Fleet" }, new SelectListItem { Text = "Admin", Value = "Admin" }, }; model.RoleTypeList = new SelectList(list2, "Value", "Text"); model.ErrorMessage = "Data Already Exist"; model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; return(View(model)); } var dto = Mapper.Map <RemarkDto>(model); dto.CreatedBy = CurrentUser.USERNAME; dto.createdDate = DateTime.Now; dto.IsActive = true; _remarkBLL.Save(dto); _remarkBLL.SaveChanges(); } catch (Exception ex) { var list1 = _documentTypeBLL.GetDocumentType(); model.DocumentTypeList = new SelectList(list1, "MstDocumentTypeId", "DocumentType"); var list2 = new List <SelectListItem> { new SelectListItem { Text = "HR", Value = "HR" }, new SelectListItem { Text = "Fleet", Value = "Fleet" }, new SelectListItem { Text = "Admin", Value = "Admin" }, }; model.RoleTypeList = new SelectList(list2, "Value", "Text"); model.ErrorMessage = ex.Message; model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; return(View(model)); } } return(RedirectToAction("Index", "MstRemark")); }