public void SaveOthersHoliday(HolidayBO holydayBo) { string queryString = ""; CommonBAL comBAL = new CommonBAL(); // holydayBo.SlNo = comBAL.GenerateID("SBP_Holiday", "Sl_No"); queryString = @"SBPSaveHoliday"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); //_dbConnection.AddParameter("@SlNo", SqlDbType.Int, holydayBo.SlNo); _dbConnection.AddParameter("@HolydayDate", SqlDbType.DateTime, holydayBo.HolydayDate.ToShortDateString()); _dbConnection.AddParameter("@Purpose", SqlDbType.VarChar, holydayBo.Purpose); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
public void _CalenderDetails(HolidayBO holidayBO) { holidayBO.createHolidayList = holidayBL.GetHolidayList(holidayBO.searchHoliday); if (holidayBO.createHolidayList != null) { var clientList = new List <object>(); holidayBO.createHolidayList.ForEach(e => { clientList.Add( new { //color="yellow", title = e.Resource + '-' + e.HolidayType + '-' + e.Status, description = e.HolidayType, start = e.HolidayDate.AddDays(1), //end = e.HolidayDate, allDay = false, // textColor="black", backgroundColor = e.Status == "Authorized" ? "green" : e.HoliColor, borderColor = e.HoliColor }); }); holidayBO.EventArray = clientList.ToArray(); } }
public ActionResult DetailsHoliday(int holidayID, int month, int employeeID, int year) { HolidayBO holidayBO = new HolidayBO(); if (holidayID != 0) { holidayBO.searchHoliday = new SearchHolidayViewModel(); holidayBO.searchHoliday.Month = month; holidayBO.searchHoliday.Year = year; holidayBO.searchHoliday.SearchResourceID = employeeID; holidayBO.detailsHoliday = new DetailsHolidayViewModel(); holidayBO.detailsHoliday.HolidayID = holidayID; holidayBO.detailsHolidayList = holidayBL.HolidayDetail(holidayBO.detailsHoliday); if (holidayBO.detailsHolidayList != null) { _ViewBagListDetails(); return(Json(new { success = true, partialview = RenderViewToString("_HolidayStatusDetails", holidayBO) })); } } _ViewBagListDetails(); return(Json(new { error = true })); }
public ActionResult Index(SearchHolidayViewModel searchHoliday) { HolidayBO holidayBO = new HolidayBO(); holidayBO.searchHoliday = searchHoliday; _CalenderDetails(holidayBO); _ViewBagListDetails(); return(View(holidayBO)); }
public ActionResult Index() { HolidayBO holidayBO = new HolidayBO(); holidayBO.searchHoliday = new SearchHolidayViewModel(); holidayBO.searchHoliday.Month = DateTime.Now.Month; holidayBO.searchHoliday.Year = DateTime.Now.Year; _CalenderDetails(holidayBO); _ViewBagListDetails(); return(View(holidayBO)); }
public ActionResult SearchHoliday(SearchHolidayViewModel searchHoliday) { HolidayBO holidayBO = new HolidayBO(); holidayBO.searchHoliday = searchHoliday; _CalenderDetails(holidayBO); if (searchHoliday.Month == null) { searchHoliday.Month = DateTime.Now.Month; } if (searchHoliday.Year == null) { searchHoliday.Year = DateTime.Now.Year; } return(PartialView("_HolidayDetail", holidayBO)); }
public ActionResult EditHoliday(int holidayID, int month, int employeeID, int year) { string msg; HolidayBO holidayBO = new HolidayBO(); if (holidayID != 0) { holidayBO.searchHoliday = new SearchHolidayViewModel(); holidayBO.searchHoliday.Month = month; holidayBO.searchHoliday.Year = year; holidayBO.searchHoliday.SearchResourceID = employeeID; holidayBO.createHoliday = new CreateHolidayViewModel(); holidayBO.createHoliday.HolidayID = holidayID; holidayBO.createHoliday.Month = month; holidayBO.createHoliday.Year = year; holidayBO.createHoliday.SearchResourceID = employeeID; holidayBO.createHoliday = holidayBL.EditHolidayDetail(holidayBO.createHoliday, out msg); if (holidayBO.createHoliday != null) { holidayBO.createHoliday.SearchHoliday = holidayBO.searchHoliday; _ViewBagListDetails(); return(Json(new { success = true, partialview = RenderViewToString("_CreateHoliday", holidayBO.createHoliday), message = msg })); } else { _CalenderDetails(holidayBO); return(Json(new { success = false, partialview = RenderViewToString("_HolidayDetail", holidayBO), message = msg })); } } //_ViewBagListDetails(); return(Json(new { error = true })); }
public ActionResult DeleteHoliday(int holidayID, int month, int employeeID, int year) { string msg; HolidayBO holidayBO = new HolidayBO(); if (holidayID != 0) { holidayBO.searchHoliday = new SearchHolidayViewModel(); holidayBO.searchHoliday.Month = month; holidayBO.searchHoliday.Year = year; holidayBO.searchHoliday.SearchResourceID = employeeID; holidayBO.searchHoliday.HolidayID = holidayID; if (holidayBL.RemoveHoliday(holidayBO.searchHoliday, out msg)) { _CalenderDetails(holidayBO); return(Json(new { success = true, partialview = RenderViewToString("_HolidayDetail", holidayBO), message = msg }, JsonRequestBehavior.AllowGet)); } else { _CalenderDetails(holidayBO); return(Json(new { success = false, partialview = RenderViewToString("_HolidayDetail", holidayBO), message = msg }, JsonRequestBehavior.AllowGet)); } } return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); }
public void Update(HolidayBO holydayBo, int holidayIdForUpdate) { string queryStringIns = ""; queryStringIns = @"SBPUpdateHoliday"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@SlNo", SqlDbType.Int, holidayIdForUpdate); _dbConnection.AddParameter("@HolydayDate", SqlDbType.DateTime, holydayBo.HolydayDate.ToShortDateString()); _dbConnection.AddParameter("@Purpose", SqlDbType.VarChar, holydayBo.Purpose); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.ExecuteNonQuery(queryStringIns); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }