public JsonResult GetRegionTypeAndChildUserType(FormCollection collection) { BAL_DoctorVisitAnalysis objBAL = new BAL_DoctorVisitAnalysis(); DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo(); DataSet ds = new DataSet(); string regionTypeCode = collection["regionType"].ToString(); ds = objBAL.GetChildRegionNameAndChildUserType(_objcurrentInfo.GetCompanyCode(), _objcurrentInfo.GetRegionCode(), regionTypeCode, _objcurrentInfo.GetUserCode()); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet)); }
public string GetBrandMasterReport(FormCollection collection) { string content = ""; BAL_DoctorVisitAnalysis objBAL = new BAL_DoctorVisitAnalysis(); DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo(); string regionCodes = collection["regionCodes"].ToString(); string userTypeCode = collection["userType"].ToString(); string month = collection["month"].ToString(); string year = collection["year"].ToString(); string dcrStatus = collection["dcrStatus"].ToString(); string userTypeName = collection["userTypeName"].ToString(); string reportName = collection["title"].ToString(); string reportMonth = collection["monthName"].ToString(); content = objBAL.GetBrandSummaryReport(_objcurrentInfo.GetCompanyCode(), regionCodes, userTypeCode, dcrStatus, month, year, userTypeName, reportMonth, reportName); return(content); }
public string GetDoctorDeviationReportDetails(string startDate, string endDate, string statusName, string userCode, string userName, string dcrStatus, string reportFormat) { StringBuilder strTblContent = new StringBuilder(); string blobUrl = string.Empty; try { DataControl.CurrentInfo objCurInfo = new CurrentInfo(); DataControl.BLUser objUser = new BLUser(); DataControl.BAL_DoctorVisitAnalysis objDoctorVisit = new BAL_DoctorVisitAnalysis(); IEnumerable <MVCModels.HiDoctor_Master.UserModel> lstUser = null; IEnumerable <MVCModels.DCRHeaderModel> lstHeader = null; IEnumerable <MVCModels.DCRDoctorVisitModel> lstDoctors = null; strTblContent.Append(objUser.GetReportHeaderTableString(objCurInfo.GetCompanyCode(), userCode, startDate, endDate, statusName, "")); lstHeader = objDoctorVisit.GetDCRHeaderByStatusAndDate(objCurInfo.GetCompanyCode(), dcrStatus, userCode, startDate, endDate); StringBuilder strAcc = new StringBuilder(); ArrayList al = new ArrayList(); if (lstHeader != null) { #region get dcr header info foreach (var dr in lstHeader) { if (!string.IsNullOrEmpty(Convert.ToString(dr.Acc1_Name))) { if (!al.Contains(Convert.ToString(dr.Acc1_Name))) { strAcc.Append(Convert.ToString(dr.Acc1_Name).Trim() + "^"); al.Add(Convert.ToString(dr.Acc1_Name).Trim()); } } if (!string.IsNullOrEmpty(Convert.ToString(dr.Acc2_Name))) { if (!al.Contains(Convert.ToString(dr.Acc2_Name))) { strAcc.Append(Convert.ToString(dr.Acc2_Name) + "^"); al.Add(Convert.ToString(dr.Acc2_Name).Trim()); } } if (!string.IsNullOrEmpty(Convert.ToString(dr.Acc3_Name))) { if (!al.Contains(Convert.ToString(dr.Acc3_Name))) { strAcc.Append(Convert.ToString(dr.Acc3_Name) + "^"); al.Add(Convert.ToString(dr.Acc3_Name).Trim()); } } if (!string.IsNullOrEmpty(Convert.ToString(dr.Acc4_Name))) { if (!al.Contains(Convert.ToString(dr.Acc4_Name))) { strAcc.Append(Convert.ToString(dr.Acc4_Name) + "^"); al.Add(Convert.ToString(dr.Acc4_Name).Trim()); } } } strAcc.Append(userName.Split(',')[0] + "^"); #endregion dcr header info lstDoctors = objDoctorVisit.GetDCRDoctorsByUserName(objCurInfo.GetCompanyCode(), dcrStatus, strAcc.ToString(), startDate, endDate); strTblContent.Append("<table class='table table-striped'>"); strTblContent.Append("<thead><tr><th>Date</th><th>" + userName + "</th>"); foreach (string accName in al) { strTblContent.Append("<th>Doctors met by " + accName + "</th>"); } strTblContent.Append("<th>Doctor Missed</th>"); strTblContent.Append("<th>Doctor Deviation</th></thead><tbody>"); if (lstDoctors != null) { foreach (var dr in lstHeader) { StringBuilder strDoctorContent = new StringBuilder(); strTblContent.Append("<tr><td>" + dr.DCR_Date + "</td>"); var disDcr = lstDoctors.AsEnumerable().Where(a => a.DCR_Actual_Date == dr.DCR_Date && a.User_Name.ToUpper() == userName.Split(',')[0].ToString().ToUpper()).ToList(); ArrayList alManagerDocs = new ArrayList(); ArrayList alChildDocs = new ArrayList(); if (disDcr.Count > 0) { strDoctorContent.Append("<table>"); foreach (var doc in disDcr) { strDoctorContent.Append("<tr><td>" + doc.Doctor_Name + "</td></tr>"); alManagerDocs.Add(doc.Doctor_Name); } strDoctorContent.Append("</table>"); strTblContent.Append("<td>" + strDoctorContent.ToString() + "</td>"); foreach (string accName in al) { StringBuilder strAccDocs = new StringBuilder(); if (accName == Convert.ToString(dr.Acc1_Name).Trim() || accName == Convert.ToString(dr.Acc2_Name).Trim() || accName == Convert.ToString(dr.Acc3_Name).Trim() || accName == Convert.ToString(dr.Acc4_Name).Trim()) { var lstAcc = lstDoctors.AsEnumerable().Where(b => b.DCR_Actual_Date == dr.DCR_Date && b.User_Name == accName).ToList(); if (lstAcc.Count > 0) { strAccDocs.Append("<table>"); foreach (var accDoc in lstAcc) { strAccDocs.Append("<tr><td>" + accDoc.Doctor_Name + "</td></tr>"); alChildDocs.Add(accDoc.Doctor_Name); } strAccDocs.Append("</table>"); } } strTblContent.Append("<td>" + strAccDocs.ToString() + "</td>"); } strDoctorContent.Clear(); #region doctor missed count if (alChildDocs.Count > 0) { strDoctorContent.Append("<table>"); foreach (string childDoctor in alChildDocs) { if (!alManagerDocs.Contains(childDoctor)) { strDoctorContent.Append("<tr><td>" + childDoctor.Trim() + "</td></tr>"); } } strDoctorContent.Append("</table>"); } strTblContent.Append("<td>" + strDoctorContent.ToString() + "</td>"); #endregion doctor missed count #region doctor deviation strDoctorContent.Clear(); int count = 0; if (alManagerDocs.Count > 0) { strDoctorContent.Append("<table>"); foreach (string managerDoctor in alManagerDocs) { if (!alChildDocs.Contains(managerDoctor)) { count++; strDoctorContent.Append("<tr><td>" + managerDoctor.Trim() + "</td></tr>"); } } strDoctorContent.Append("</table>"); if (count < 0) { strDoctorContent.Clear(); } } strTblContent.Append("<td>" + strDoctorContent + "</td>"); #endregion doctor deviation } strTblContent.Append("</tr>"); } } } if (reportFormat == "2") { DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload(); DataControl.CurrentInfo _objCurr = new CurrentInfo(); DataControl.Abstraction.IConfigProvider iConfigPro = new DataControl.Impl.ConfigProvider(); DataControl.Repository.AzureBlobUpload objAzureBlob = new DataControl.Repository.AzureBlobUpload(); string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY"); string compCode = _objCurr.GetCompanyCode(); string fileName = "DoctorDeviationReport_" + "_" + compCode + "_" + _objCurr.GetUserName() + ".xls"; string error = string.Empty; //string strExcelContent = GetDoctorDeviationReportDetails(startDate,endDate,statusName,userCode,userName,dcrStatus); blobUrl = objAzureBlob.AzureBlobUploadText(strTblContent.ToString(), accKey, fileName, "bulkdatasvc"); } } catch (Exception ex) { } if (reportFormat == "1") { return(strTblContent.ToString()); } else { return(blobUrl); } }