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