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");
}
}
