public string GenerateYearWiseHolidayExcel(string regionCodes, string year, string SearchKey, int pageNumber, bool excelDownload)
{
int count = 0;
int totalPageCount = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
lstHoliday = objRegion.GetMappedHolidayDetails(objCurInfo.GetCompanyCode(), regionCodes, year, SearchKey, pageNumber, excelDownload, PAGESIZE,
ref totalPageCount);
StringBuilder strContent = new StringBuilder();
StringBuilder strExcelContent = new StringBuilder();
strExcelContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Date</td><td>Holiday Name</td>");
strExcelContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstHoliday != null)
{
int i = 0;
foreach (var dr in lstHoliday)
{
i++;
strExcelContent.Append("<tr><td>" + i + "</td>");
strExcelContent.Append("<td><span id='lblHolidayDate_" + i + "'>" + dr.Holiday_Date + "</span></td>");
strExcelContent.Append("<td><span id='lblHolidayName_" + i + "'>" + dr.Holiday_Name + "</span></td>");
strExcelContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></td>");
strExcelContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strExcelContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strExcelContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strExcelContent.Append("</tr>");
}
}
strExcelContent.Append("</tbody></table>");
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider();
DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload();
string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
string userName = objCurInfo.GetUserName();
string subDomin = objCurInfo.GetSubDomain();
string fileName = "HolidayMaster" + "_" + subDomin + "_" + userName + ".xls";
string blobUrl = string.Empty;
blobUrl = objAzureBlob.AzureBlobUploadText(strExcelContent.ToString(), accKey, fileName, "bulkdatasvc");
return(blobUrl);
}
public string GetMappedHolidayDetails(string regionCodes, string year, string SearchKey, int pageNumber, bool excelDownload)
{
int count = 0;
int totalPageCount = 0;
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLRegion objRegion = new DataControl.BLRegion();
IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null;
lstHoliday = objRegion.GetMappedHolidayDetails(objCurInfo.GetCompanyCode(), regionCodes, year, SearchKey, pageNumber, excelDownload, PAGESIZE,
ref totalPageCount);
StringBuilder strContent = new StringBuilder();
strContent.Append(Pager.Paging(pageNumber, totalPageCount));
StringBuilder strExcelContent = new StringBuilder();
strContent.Append("<table class='table table-striped'><thead><tr><td>S.No</td><td>Edit</td><td>Delete</td><td>Date</td><td>Holiday Name</td>");
strContent.Append("<td>Region Name</td><td>Region Type</td><td>Reporting Region</td><td>Reporting Region Type</td></tr></thead>");
if (lstHoliday != null)
{
int i = 0;
foreach (var dr in lstHoliday)
{
i++;
strContent.Append("<tr><td>" + i + "</td>");
strContent.Append("<td><a id='aEdit_" + i + "' onclick='fnEditHoliday(\"" + dr.Holiday_Code + "\",this)'>Edit</a></td>");
strContent.Append("<td><a id='aDelete_" + i + "' onclick='fnDeleteHoliday(\"" + dr.Holiday_Code + "\",this)'>Delete</a></td>");
strContent.Append("<td><span id='lblHolidayDate_" + i + "'>" + dr.Holiday_Date + "</span></td>");
strContent.Append("<td><span id='lblHolidayName_" + i + "'>" + dr.Holiday_Name + "</span></td>");
strContent.Append("<td>" + dr.Region_Name + "<input type='hidden' id='hdnRegionCode_" + i + "' value='" + dr.Region_Code + "'/></td>");
strContent.Append("<td>" + dr.Region_Type_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Name + "</td>");
strContent.Append("<td>" + dr.Reporting_Region_Type_Name + "</td>");
strContent.Append("</tr>");
}
}
strContent.Append("</tbody></table>");
return(strContent.ToString());
}
