public HolidayInfoModel GetHolidays(string companyCode, string Region_Code)
{
HolidayInfoModel objholiday = null;
List <Holiday> lstregionholiday = null;
List <Holiday> lstholidayyear = null;
try
{
using (IDbConnection connection = IDbOpenConnection())
{
var p = new DynamicParameters();
p.Add("@Company_Code", companyCode);
p.Add("@Region_Code", Region_Code);
using (var multiselect = connection.QueryMultiple(SP_HD_GetHolidaysforRegion, p, commandType: CommandType.StoredProcedure))
{
lstregionholiday = multiselect.Read <Holiday>().ToList();
lstholidayyear = multiselect.Read <Holiday>().ToList();
}
objholiday = new HolidayInfoModel();
objholiday.lstregionholiday = lstregionholiday;
objholiday.lstholidayyear = lstholidayyear;
connection.Close();
}
}
catch (Exception ex)
{
throw;
}
return(objholiday);
}
public HolidayInfoModel GetHolidays(string companyCode, string Region_Code)
{
HolidayInfoModel lstregionholiday = null;
try
{
DAL_RegionCreation _objDal = new DAL_RegionCreation();
lstregionholiday = _objDal.GetHolidays(companyCode, Region_Code);
}
catch (Exception ex)
{
throw;
}
return(lstregionholiday);
}
public JsonResult GetHolidays(string RegionCode)
{
string companyCode = null;
HolidayInfoModel lstholidays = null;
try
{
_objCurrInfo = new CurrentInfo();
companyCode = _objCurrInfo.GetCompanyCode();
lstholidays = _objbl.GetHolidays(companyCode, RegionCode);
return(Json(lstholidays, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw;
}
}
