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