public string GetSearchHolidayDetails(string holidayDate) { int count = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLRegion objRegion = new DataControl.BLRegion(); IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null; string date = holidayDate.Split('/')[2] + "-" + holidayDate.Split('/')[1] + "-" + holidayDate.Split('/')[0]; lstHoliday = objRegion.GetHolidayDetailsByDate(objCurInfo.GetCompanyCode(), date); StringBuilder strContent = new StringBuilder(); strContent.Append("<table class='table table-striped'><thead><tr><td>S.No</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>" + dr.Holiday_Date + "</td>"); strContent.Append("<td>" + dr.Holiday_Name + "</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()); }
public JsonResult GetMappedHolidaysByDate(string holidayDate) { int count = 0; DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BLRegion objRegion = new DataControl.BLRegion(); IEnumerable <MVCModels.HiDoctor_Master.HolidayModel> lstHoliday = null; string date = holidayDate.Split('/')[2] + "-" + holidayDate.Split('/')[1] + "-" + holidayDate.Split('/')[0]; lstHoliday = objRegion.GetHolidayDetailsByDate(objCurInfo.GetCompanyCode(), date); DataControl.JSONConverter objJson = new DataControl.JSONConverter(); return(Json(objJson.Serialize(lstHoliday))); }