public JsonResult UploadFile(HttpPostedFileBase upload) { var qtyPacked = string.Empty; var qty = string.Empty; var data = (new ExcelReader()).ReadExcel(upload); var model = new List <HolidayCalenderItem>(); if (data != null) { foreach (var dataRow in data.DataRows) { if (dataRow[0] == "") { continue; } var item = new HolidayCalenderItem(); try { double MstHolidayDate = double.Parse(dataRow[0].ToString()); item.MstHolidayDate = DateTime.FromOADate(MstHolidayDate); item.Description = dataRow[1].ToString(); //item.IsActive = dataRow[2].ToString() == "Active"? true : false; model.Add(item); } catch (Exception ex) { var a = ex.Message; } } } return(Json(model)); }
public ActionResult Create() { var model = new HolidayCalenderItem(); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; model.MstHolidayDate = DateTime.Today; return(View(model)); }
public ActionResult Detail(int MstHolidayCalenderId) { var data = _HolidayCalenderBLL.GetholidayCalenderById(MstHolidayCalenderId); var model = new HolidayCalenderItem(); model = Mapper.Map <HolidayCalenderItem>(data); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; model.ChangesLogs = GetChangesHistory((int)Enums.MenuList.MasterHoliday, MstHolidayCalenderId); return(View(model)); }
public ActionResult Edit(HolidayCalenderItem model) { if (ModelState.IsValid) { var data = Mapper.Map <HolidayCalenderDto>(model); data.ModifiedDate = DateTime.Now; data.ModifiedBy = CurrentUser.USERNAME; _HolidayCalenderBLL.Save(data, CurrentUser); } return(RedirectToAction("Index", "MstHolidayCalender")); }
public ActionResult Create(HolidayCalenderItem model) { if (ModelState.IsValid) { var data = Mapper.Map <HolidayCalenderDto>(model); data.CreatedBy = CurrentUser.USERNAME; data.CreatedDate = DateTime.Now; data.IsActive = true; try { _HolidayCalenderBLL.Save(data); } catch (Exception) { var list1 = _pageBLL.GetPages(); model.ModulList = new SelectList(list1, "MST_MODUL_ID", "MODUL_NAME"); model.MainMenu = _mainMenu; model.CurrentLogin = CurrentUser; return(View(model)); } } return(RedirectToAction("Index", "MstHolidayCalender")); }