public string GetTPDoctorDetailsForAluminiUsers(string tpDate, string userCode) { StringBuilder strContent = new StringBuilder(); try { DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BL_Report objReport = new DataControl.BL_Report(); List <MVCModels.HiDoctor_Master.DoctorModel> lstDoctor = new List <MVCModels.HiDoctor_Master.DoctorModel>(objReport.GetTPDoctorDetailsForAlumniUsers(objCurInfo.GetCompanyCode(), tpDate, userCode)); strContent.Append("<table class='table table-striped' id='tbl_Details'>"); strContent.Append("<thead>"); strContent.Append("<tr id='tblTrpopup'>"); strContent.Append("<th>MDL NO</th>"); strContent.Append("<th>Doctor Name</th>"); strContent.Append("<th>Speciality</th>"); strContent.Append("</tr>"); strContent.Append("</thead>"); strContent.Append("<tbody>"); if (lstDoctor.Count > 0) { for (var i = 0; i < lstDoctor.Count; i++) { strContent.Append("<tr>"); strContent.Append("<td>" + lstDoctor[i].MDL_Number + "</td>"); strContent.Append("<td>" + lstDoctor[i].Customer_Name + "</td>"); strContent.Append("<td>" + lstDoctor[i].Speciality_Name + "</td>"); strContent.Append("</tr>"); } } strContent.Append("</tbody>"); strContent.Append("</table>"); } catch (Exception ex) { } return(strContent.ToString()); }
///// <summary> ///// Get TP Master report for alumini users ///// </summary> ///// <param name="userCode"></param> ///// <param name="date"></param> ///// <returns>return the table content</returns> public string GetTPMasterReportForAluminiUsers(string userCode, string month, string year, string isExcel, string monthName) { StringBuilder strContent = new StringBuilder(); DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo(); DataControl.BL_Report objReport = new DataControl.BL_Report(); DataControl.BLUser objUser = new DataControl.BLUser(); #region tp header strContent.Append(objUser.GetReportHeaderTableString(objCurInfo.GetCompanyCode(), userCode, monthName + "-" + year, "", "", "")); strContent.Append("<table class='table table-striped' cellpadding=0 cellspacing=0 id ='tblTPReport'>"); strContent.Append("<thead>"); strContent.Append("<tr id='tblTr'>"); strContent.Append("<th>User Name</th>"); strContent.Append("<th>TP Date</th>"); strContent.Append("<th>Call Objective</th>"); strContent.Append("<th>Activity Name</th>"); strContent.Append("<th>Category</th>"); strContent.Append("<th>CP Name</th>"); strContent.Append("<th>Meeting Point </th>"); strContent.Append("<th>Meeting Time </th>"); strContent.Append("<th>Work Place</th>"); strContent.Append("<th>SFC</th>"); strContent.Append("<th>Accomp Name</th>"); strContent.Append("<th>No oF Planned Doctors</th>"); strContent.Append("<th>Entered Date</th>"); strContent.Append("<th>Entered By</th>"); strContent.Append("<th>Remarks</th>"); strContent.Append("<th>Status</th>"); strContent.Append("<th>Approved/Unapproved Date</th>"); strContent.Append("<th>Approve/Unapprove Reason</th>"); strContent.Append("</tr>"); strContent.Append("</thead>"); strContent.Append("<tbody>"); #endregion tp header try { DataSet ds = new DataSet(); ds = objReport.GetTPMasterReportForAlumniUsers(objCurInfo.GetCompanyCode(), month, year, userCode); if (ds.Tables.Count > 0) { int noOfDays = System.DateTime.DaysInMonth(Convert.ToInt32(year), Convert.ToInt32(month)); DateTime startDate = Convert.ToDateTime(year + "-" + month + "-01"); DateTime endDate = Convert.ToDateTime(year + "-" + month + "-" + noOfDays); DateTime dtStartDate = new DateTime(); DateTime dtEndDate = new DateTime(); dtStartDate = Convert.ToDateTime(startDate); dtEndDate = Convert.ToDateTime(endDate); DateTime dtDate = dtStartDate; TimeSpan ts; ts = dtEndDate - dtStartDate; for (var j = 0; j <= ts.Days; j++) { if (j != 0) { dtDate = dtDate.AddDays(Convert.ToDouble(1)); } DataRow[] dr = ds.Tables[0].AsEnumerable().Where(a => Convert.ToInt32(a["Day"]) == dtDate.Day && Convert.ToInt32(a["Month"]) == dtDate.Month && Convert.ToInt32(a["Year"]) == dtDate.Year).ToArray(); if (dr.Length > 0) { strContent.Append("<tr>"); strContent.Append("<td>" + Convert.ToString(dr[0]["User_Name"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["TP_Date"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Activity_Code"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Project_Code"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Category"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["CP_name"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Meeting_point"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Meeting_Time"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Work_Area"]) + "</td>"); #region TP SFC details // var sfcDet = jsonPath(jsData, "$.Tables[4].Rows[?(@.TP_Id=='" + details[0].TP_Id + "')]"); DataRow[] drSFC = ds.Tables[2].AsEnumerable().Where(z => Convert.ToString(z["TP_Id"]) == Convert.ToString(dr[0]["TP_Id"])).ToArray(); StringBuilder strSFC = new StringBuilder(); if (drSFC.Length > 0) { for (int s = 0; s < drSFC.Length; s++) { if (!string.IsNullOrEmpty(Convert.ToString(drSFC[s]["From_Place"]))) { strSFC.Append("" + (s + 1) + "/ " + Convert.ToString(drSFC[s]["From_Place"]) + " to " + Convert.ToString(drSFC[s]["To_Place"]) + "<br />"); } } } strContent.Append("<td>" + strSFC.ToString() + "</td>"); #endregion TP SFC details StringBuilder strAccName = new StringBuilder(); if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accomp_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accomp_Name"]) + " <br />"); } if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accompanist2_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accompanist2_Name"]) + "<br />"); } if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accompanist3_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accompanist3_Name"]) + "<br />"); } if (!string.IsNullOrEmpty(Convert.ToString(dr[0]["Accompanist4_Name"]))) { strAccName.Append("" + Convert.ToString(dr[0]["Accompanist4_Name"]) + "<br /> "); } strContent.Append("<td>" + strAccName.ToString() + "</td>"); DataRow[] drDoctors = ds.Tables[1].AsEnumerable().Where(c => Convert.ToString(c["TP_Date"]) == Convert.ToString(dr[0]["TP_Date"])).ToArray(); if (drDoctors.Length > 0) { // content += "<td>" + dJsonData.length + "</td>"; strContent.Append("<td align='center' ><span onclick='fnTPDetails(\"" + userCode + "_" + dr[0]["TP_Date"] + "\")' style='text-decoration:underline;cursor:pointer'>" + drDoctors.Length + "</span></td>"); } else { strContent.Append("<td></td>"); } strContent.Append("<td>" + Convert.ToString(dr[0]["Entered_Date"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Entered_by"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Remarks"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Status"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Approved_Date"]) + "</td>"); strContent.Append("<td>" + Convert.ToString(dr[0]["Unapprove_Reason"]) + "</td>"); strContent.Append("</tr>"); } else { #region holiday details DataRow[] drHoliday = ds.Tables[3].AsEnumerable().Where(a => Convert.ToInt32(a["Day"]) == dtDate.Day && Convert.ToInt32(a["Month"]) == dtDate.Month && Convert.ToInt32(a["Year"]) == dtDate.Year).ToArray(); // var details = jsonPath(jsData, "$.Tables[5].Rows[?(@.Day=='" + day + "' & @.Month=='" + month + "' & @.Year=='" + year + "')]"); if (drHoliday.Length > 0) { if (Convert.ToString(drHoliday[0]["Type"]) == "S") { strContent.Append("<tr>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'>" + Convert.ToString(drHoliday[0]["Date"]) + "</td>"); strContent.Append("<td style='background: #efefef;'> - Sunday</td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("</tr>"); } else { strContent.Append("<tr>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'>" + Convert.ToString(drHoliday[0]["Date"]) + "</td>"); strContent.Append("<td style='background: #efefef;'> - Holiday - </td>"); strContent.Append("<td style='background: #efefef;'>" + Convert.ToString(drHoliday[0]["Holiday"]) + "</td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("<td style='background: #efefef;'></td>"); strContent.Append("</tr>"); } } #endregion holiday details } } } } catch (Exception ex) { } strContent.Append("</tbody>"); strContent.Append("</table>"); string blobUrl = string.Empty; if ("Y" == isExcel) { 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 compCode = objCurInfo.GetCompanyCode(); string fileName = "TPMASTERALUMINI_" + "_" + compCode + "_" + userName + ".xls"; blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc"); strContent.Clear(); strContent.Append(blobUrl); } return(strContent.ToString()); }