public JsonResult GetAssertDetails(string regionCode, string speciality_Code, string category_Code, string period) { BL_EdReports _objRpt = new BL_EdReports(); DataSet ds = _objRpt.GetAssertDetails(regionCode, speciality_Code, category_Code, period, _objcurrentInfo.GetSubDomain()); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet)); }
public JsonResult GetChildUserCheck(FormCollection collection) { DataSet dsChildUsers = new DataSet(); dsChildUsers = objSP.dsChildUsers(objCurr.GetCompanyCode(), objCurr.GetUserCode()); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(dsChildUsers))); }
public string GetActivitySummarDetailReport(FormCollection collection) { string userDetails = collection["userDetails"].ToString(); DataSet ds = new DataSet(); ds = objSP.GetActivitySummarDetailsReport(objCurr.GetCompanyCode(), userDetails.Split('_')[0], userDetails.Split('_')[1], userDetails.Split('_')[5], userDetails.Split('_')[2], userDetails.Split('_')[3]); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(GetActivitySummarDetailReportTable(ds, userDetails)); }
public JsonResult GetChildUserDetails(FormCollection collection) { string userName = collection["userName"].ToString(); DataSet dsChildUsers = new DataSet(); dsChildUsers = objSP.dsChildUserSearch(objCurr.GetCompanyCode(), objCurr.GetUserCode(), userName); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(dsChildUsers))); }
public JsonResult GetAssetWiseEdetailing(string RegionCode, string Spl_Month, string Spl_Year, string IsTeam) { DataSet ds = new DataSet(); BL_EdReports _objRpt = new BL_EdReports(); string period = Spl_Year + "-" + Spl_Month + "-01"; ds = _objRpt.GetAssetWiseEdetailing(RegionCode, _objcurrentInfo.GetSubDomain(), period, IsTeam); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(ds), JsonRequestBehavior.AllowGet)); }
//fill grid public string GetRequestmapValues() { DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); string companyCode = _objCurInfo.GetCompanyCode(); try { DataControl.JSONConverter json = new DataControl.JSONConverter(); List <RequestModel> lstRequestMap = new List <RequestModel>(); DataControl.BLMaster _objMapping = new DataControl.BLMaster(); StringBuilder sbTableContent = new StringBuilder(); lstRequestMap = (List <RequestModel>)_objMapping.GetRequestMapDetails(companyCode); if (lstRequestMap != null && lstRequestMap.Count > 0) { sbTableContent.Append("<table id='tblrequest' class='table table-striped' >"); sbTableContent.Append("<thead class='active'>"); sbTableContent.Append("<tr style='background-color: #428bca'>"); sbTableContent.Append("<td>Edit</td>"); sbTableContent.Append("<td>Change Status</td>"); sbTableContent.Append("<td>Request</td>"); sbTableContent.Append("<td>UserType</td>"); sbTableContent.Append("<td>Status</td>"); sbTableContent.Append("</tr>"); sbTableContent.Append("</thead>"); sbTableContent.Append("<tbody>"); int i = 0; foreach (var item in lstRequestMap) { i++; sbTableContent.Append("<tr><td><a href='#' onclick ='fnEdit(\"" + item.Request_Code.ToString() + "_" + item.User_Type_Code.ToString() + "_" + item.Request_Mapping_Code.ToString() + "\");'>Edit</a></td>"); sbTableContent.Append("<td><a href='#' onclick ='fnStatusChange(\"" + item.Request_Mapping_Code.ToString() + "_" + item.Record_Status.ToString() + "\");'>Change Status</a></td>"); sbTableContent.Append("<td>" + item.Request_Name.ToString() + "</td>"); sbTableContent.Append("<td>" + item.User_Type_Name.ToString() + "</td>"); sbTableContent.Append("<td>" + item.Status.ToString() + "</td></tr>"); } } sbTableContent.Append("</tbody>"); sbTableContent.Append("</table>"); return(sbTableContent.ToString() + "*" + json.Serialize(lstRequestMap)); } catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:companyCode", companyCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return("Sorry an error occured. Please try again later."); } }
public string GetActivitySummarReport(FormCollection collection) { string userCode = collection["userCode"].ToString(); if (userCode.ToUpper() == "MINE") { userCode = objCurr.GetUserCode(); } DataSet ds = new DataSet(); ds = objSP.GetActivitySummarReport(objCurr.GetCompanyCode(), userCode); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(GetActivitySummarReportTable(ds)); }
public JsonResult GetDoctor360Details(string doctorCode) { DataSet dsTpHeader = new DataSet(); string userCode = doctorCode.Split('_')[1].ToString(); string regionCode = doctorCode.Split('_')[0].ToString(); string customerCode = doctorCode.Split('_')[2].ToString(); objData.OpenConnection(objCurr.GetCompanyCode()); { dsTpHeader = objData.ExecuteDataSet("exec SP_hdGetDoctor360Details '" + objCurr.GetCompanyCode() + "','" + customerCode + "','" + regionCode + "','" + userCode + "'"); } objData.CloseConnection(); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(dsTpHeader))); }
public JsonResult GetTPHeader(string userCode) { if (userCode.ToUpper() == "MINE") { userCode = objCurr.GetUserCode(); } DataSet dsTpHeader = new DataSet(); objData.OpenConnection(objCurr.GetCompanyCode()); { dsTpHeader = objData.ExecuteDataSet("exec SP_mhdGetTPReport '" + objCurr.GetCompanyCode() + "','" + userCode + "'"); } objData.CloseConnection(); DataControl.JSONConverter json = new DataControl.JSONConverter(); return(Json(json.Serialize(dsTpHeader))); }
public string GetSMSDetails(string userCode) { DataControl.JSONConverter json = new DataControl.JSONConverter(); List <SendSMS> lstSentSMSDetails = new List <SendSMS>(); DataControl.BLMaster _objMapping = new DataControl.BLMaster(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); StringBuilder sbTableContent = new StringBuilder(); lstSentSMSDetails = (List <SendSMS>)_objMapping.GetSentSMSDetails(userCode); try { if (lstSentSMSDetails != null && lstSentSMSDetails.Count > 0) { sbTableContent.Append("<h4>User Name : " + lstSentSMSDetails[0].User_Name.ToString() + "</h4>"); sbTableContent.Append("<table id='tblUserInfo' class='table table-striped'>"); sbTableContent.Append("<thead class='active' style='display:block;text-align: center;' >"); sbTableContent.Append("<tr style='background-color: #428bca'>"); sbTableContent.Append("<td>Sender Name</td>"); //sbTableContent.Append("<td>User Name</td>"); sbTableContent.Append("<td>Mobile Number</td>"); sbTableContent.Append("<td>Date & Time</td>"); sbTableContent.Append("<td style='min-width: 319px;'>SMS Details</td>"); sbTableContent.Append("</tr>"); sbTableContent.Append("</thead>"); sbTableContent.Append("<tbody style='overflow-y: scroll;display: block;height: 300px;'>"); foreach (var item in lstSentSMSDetails) { sbTableContent.Append("<td>" + item.Sender_User_Name.ToString() + "</td>"); //sbTableContent.Append("<td>" + item.User_Name.ToString() + "</td>"); sbTableContent.Append("<td style ='min-width: 101px;'>" + item.Mobile_Number.ToString() + "</td>"); sbTableContent.Append("<td style ='min-width: 84px;'>" + item.Date_Time.ToString() + "</td>"); sbTableContent.Append("<td>" + item.SMS_Details.ToString() + "</td></tr>"); } sbTableContent.Append("</tbody>"); sbTableContent.Append("</table>"); } return(sbTableContent.ToString()); } catch (Exception ex) { return("Sorry an error occured. Please try again later."); } }
public JsonResult GetWeekendGroup(FormCollection collection) { try { string RegionCode = string.Empty; RegionCode = collection["RegionCode"]; string mode = string.Empty; mode = collection["Mode"]; DataSet dsReport = new DataSet(); DataControl.JSONConverter json = new DataControl.JSONConverter(); _objData.OpenConnection(_objcurrentInfo.GetCompanyCode()); dsReport = _objSPData.GetWeekendgroupdetail(_objcurrentInfo.GetCompanyCode(), RegionCode, mode); //dsReport = _objData.ExecuteDataSet("EXEC SP_hdGETRegionWeekengGroupMapping " + "'" + _objcurrentInfo.GetCompanyCode() + "','" + RegionCode + "'"); return(Json(json.Serialize(dsReport), JsonRequestBehavior.AllowGet)); } finally { _objData.CloseConnection(); } }
public string GetUserInfo(string fromDate, string toDate) { DataControl.JSONConverter json = new DataControl.JSONConverter(); List <SendSMS> lstUserInfo = new List <SendSMS>(); DataControl.BLMaster _objMapping = new DataControl.BLMaster(); DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo(); string companyCode = _objCurInfo.GetCompanyCode(); StringBuilder sbTableContent = new StringBuilder(); lstUserInfo = (List <SendSMS>)_objMapping.GetUserInfoDetails(companyCode, fromDate, toDate); try { if (lstUserInfo != null && lstUserInfo.Count > 0) { sbTableContent.Append("<table id='tblUserInfo' class='table table-striped' style='text-align: center;'>"); sbTableContent.Append("<thead class='active'>"); sbTableContent.Append("<tr style='background-color: #428bca;text-align: center;'>"); sbTableContent.Append("<td><input type='checkbox' id='bulkcheck'name='bulkchk_User' onclick='fnselectall()'/></td>"); sbTableContent.Append("<td>Employee Name</td>"); sbTableContent.Append("<td>Employee Number</td>"); sbTableContent.Append("<td>User Name</td>"); sbTableContent.Append("<td>Designation</td>"); sbTableContent.Append("<td>Region Name</td>"); sbTableContent.Append("<td>Reporting To</td>"); sbTableContent.Append("<td>Created Date</td>"); sbTableContent.Append("<td>HiDocotor Start Date</td>"); sbTableContent.Append("<td>Division</td>"); sbTableContent.Append("<td>Sent SMS Count</td>"); sbTableContent.Append("</tr>"); sbTableContent.Append("</thead>"); sbTableContent.Append("<tbody>"); foreach (var item in lstUserInfo) { var userCode_ = item.User_Code.ToString(); sbTableContent.Append("<tr><td><input type='checkbox' id='Chk_UserInfo_' value=" + userCode_ + " name='chk_UserInfo' /></td>"); sbTableContent.Append("<td>" + item.Employee_Name.ToString() + "</td>"); sbTableContent.Append("<td>" + item.Employee_Number.ToString() + "</td>"); sbTableContent.Append("<td>" + item.User_Name.ToString() + "</td>"); sbTableContent.Append("<td>" + item.User_Type_Name.ToString() + "</td>"); //Designation sbTableContent.Append("<td>" + item.Region_Name.ToString() + "</td>"); sbTableContent.Append("<td>" + item.Under_User_Name.ToString() + "</td>"); //Reporting To sbTableContent.Append("<td>" + item.Created_Date.ToString() + "</td>"); sbTableContent.Append("<td>" + item.HiDoctor_Start_Date.ToString() + "</td>"); sbTableContent.Append("<td>" + item.Division_Name.ToString() + "</td>"); if (item.SMS_count.ToString() == "0") { sbTableContent.Append("<td>" + item.SMS_count.ToString() + "</td>"); } else { sbTableContent.Append("<td><a title='View Details' onClick='fnGetSentSMSDetails(\"" + item.User_Code + "\");'href='#'>" + item.SMS_count.ToString() + "</a></td></tr>"); } } sbTableContent.Append("</tbody>"); sbTableContent.Append("</table>"); } return(sbTableContent.ToString()); } // return Json(lstUserInfo, JsonRequestBehavior.AllowGet); catch (Exception ex) { Dictionary <string, string> dicContext = new Dictionary <string, string>(); dicContext.Add("Filter:companyCode", companyCode); DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext); return("Sorry an error occured. Please try again later."); } }
public string GetForgotpassword(FormCollection collection) { try { string userName = string.Empty; userName = collection["UserName"]; string result = ""; DataSet dsReport = new DataSet(); DataControl.JSONConverter json = new DataControl.JSONConverter(); try { _objData.OpenConnection(_objcurrentInfo.GetCompanyCode()); dsReport = _objData.ExecuteDataSet("EXEC SP_HdGetCheckUsername " + "'" + _objcurrentInfo.GetCompanyCode() + "','" + userName + "'"); } finally { _objData.CloseConnection(); } if (dsReport.Tables[0].Rows.Count != 0) { string strEmailid = dsReport.Tables[0].Rows[0]["Email_Id"].ToString(); string UserName = dsReport.Tables[0].Rows[0]["User_Name"].ToString(); string strUserpass = dsReport.Tables[0].Rows[0]["User_Pass"].ToString(); if (!string.IsNullOrEmpty(strEmailid)) { //string strSubject = "Dear Sir/Madam, \n\n Please keep a note of the following information which is critical for ensuring uninterrupted access to HiDOCTOR \n\n Your User Id: " + UserName + " \n Your Password: "******" \n\n In case of any clarifications, please reach out to our support desk ([email protected] or 095600005628).\n\n Assuring you of our best services at all times.\n\n Warm Regards \n Customer Service "; string companyName = ""; string employeeName = ""; string phoneNo = "Not yet registered in HiDOCTOR"; string mobileNo = "Not yet registered in HiDOCTOR"; DataSet dsEmpInfo = new DataSet(); try { _objData.OpenConnection(_objcurrentInfo.GetCompanyCode()); dsEmpInfo = _objData.ExecuteDataSet("EXEC SP_HdGetEmployeeDetail " + "'" + _objcurrentInfo.GetCompanyCode() + "','" + userName + "'"); } finally { _objData.CloseConnection(); } if (dsEmpInfo.Tables[0].Rows.Count > 0) { companyName = dsEmpInfo.Tables[0].Rows[0]["Company_Name"].ToString().Trim(); employeeName = dsEmpInfo.Tables[0].Rows[0]["Employee_Name"].ToString().Trim(); if (dsEmpInfo.Tables[0].Rows[0]["Phone"].ToString().Trim().Length > 0) { phoneNo = dsEmpInfo.Tables[0].Rows[0]["Phone"].ToString().Trim(); } if (dsEmpInfo.Tables[0].Rows[0]["Mobile"].ToString().Trim().Length > 0) { mobileNo = dsEmpInfo.Tables[0].Rows[0]["Mobile"].ToString().Trim(); } } string server = ConfigurationManager.AppSettings["SMTPSERVER"]; string frommail = ConfigurationManager.AppSettings["FROMMAIL"]; string strSubject = Resources.Password_Policy_Messages.PasswordLockReleaseMail.ToString(); string strSubjectNew = strSubject.Replace("@Name", UserName).Replace("@Pass", strUserpass); strSubjectNew = strSubjectNew.Replace("@CompanyName", companyName); strSubjectNew = strSubjectNew.Replace("@EmployeeName", employeeName); strSubjectNew = strSubjectNew.Replace("@PhoneNo", phoneNo); strSubjectNew = strSubjectNew.Replace("@MobileNo", mobileNo); bool Issmtpmail = false; Issmtpmail = _objSPData.SendMail(strEmailid, "Check your HiDOCTOR Password", strSubjectNew); return("SUCCESS"); } else { return("MAIL"); } } else { return("FAILED"); } } catch { return("FAILED"); } }