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