public JsonResult Getrequest()
{
DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
RequestModel objDroRequest = new RequestModel();
objDroRequest.Company_Code = _objcurrentInfo.GetCompanyCode();
try
{
IEnumerable <RequestModel> lstRequest = _objBlmaster.GetRequest(objDroRequest);
var requestlist = (from request in lstRequest.AsEnumerable()
select new RequestModel()
{
Request_Code = request.Request_Code.ToString(),
Request_Name = request.Request_Name.ToString()
}).ToList <RequestModel>();
return(Json(requestlist));
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", objDroRequest.Company_Code);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(Json("Sorry an error occured. Please try again later."));
}
}
/// <summary>
/// Get under Usertype Name
/// </summary>
/// <returns></returns>
public JsonResult GetUserType()
{
DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
DivisionUserProducts objDroUserType = new DivisionUserProducts();
objDroUserType.Company_Code = _objcurrentInfo.GetCompanyCode();
// objDroUserType.User_Code = _objcurrentInfo.GetUserCode();
try
{
IEnumerable <DivisionUserProducts> lstUsertype = _objBlmaster.GetUserTypeNames(objDroUserType);
var userTypelist = (from userType in lstUsertype.AsEnumerable()
select new DivisionUserProducts()
{
User_Type_Code = userType.User_Type_Code.ToString(),
User_Type_Name = userType.User_Type_Name.ToString()
}).ToList <DivisionUserProducts>();
return(Json(userTypelist));
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", objDroUserType.Company_Code);
dicContext.Add("Filter:userCode", objDroUserType.User_Code);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(Json("Sorry an error occured. Please try again later."));
}
}
//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 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 int UpdateRequestMapping(string requestCode, string userTypeCode, string mapCode)
{
DataControl.BLMaster _objMapping = new DataControl.BLMaster();
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
string companyCode = objCurInfo.GetCompanyCode();
try
{
int result = _objMapping.UpdateRequestMapping(companyCode, requestCode, userTypeCode, mapCode);
return(result);
}
catch (Exception ex) {
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:companyCode", companyCode);
dicContext.Add("Filter:requestCode", requestCode);
dicContext.Add("Filter:userTypeCode", userTypeCode);
dicContext.Add("Filter:userTypeCode", mapCode);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return(2);
}
}
public string SendPassword(string userCode, string createdDate, string hiDoctorStartDate)
{
try
{
StringBuilder sbTableContent = new StringBuilder();
int successcount = 0;
int failurecount = 0;
string mesgalert = string.Empty;
string failure = string.Empty;
string url = string.Empty;
string message = string.Empty;
string userName = string.Empty;
string password = string.Empty;
string mobileno = string.Empty;
Regex regExInt = new Regex("^([0-9]*)$");
List <SendSMS> lstUser = new List <SendSMS>();
DataControl.BLMaster _objMapping = new DataControl.BLMaster();
DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
string companyCode = _objCurInfo.GetCompanyCode();
string companyId = _objCurInfo.GetCompanyId();
string senderCode = _objCurInfo.GetUserCode();
string senderName = _objCurInfo.GetUserName();
lstUser = (List <SendSMS>)_objMapping.GetUserDetails(companyCode, userCode);
url = "https://" + Request.Url.DnsSafeHost;
foreach (var user in lstUser)
{
userCode = user.User_Code.ToString();
userName = user.User_Name.ToString();
password = user.User_Pass.ToString();
mobileno = user.Mobile.ToString();
message = "Welcome to HiDoctor. Website address for online reporting: [variable1] Your user name is [variable2] and password is [variable3].";
message = message.Replace("[variable1]", url).Replace("[variable2]", userName).Replace("[variable3]", password);
if (!string.IsNullOrEmpty(mobileno))
{
if (mobileno.Length == 10 && regExInt.IsMatch(mobileno))
{
HttpWebRequest request = (HttpWebRequest)
WebRequest.Create("http://www.smsintegra.co.in/smsweb/desktop_sms/desktopsms.asp?uid=swaassys&pwd=963900&mobile=" + mobileno + "&msg=" + message + "&sid=HIDOCT&dtNow=" + DateTime.Now.ToString("yyyy-MM-dd") + "");
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
using (Stream responseStream = response.GetResponseStream())
{
using (StreamReader readStream = new StreamReader(responseStream, Encoding.UTF8))
{
string strSMSResponseString = readStream.ReadToEnd();
if (strSMSResponseString.StartsWith("100"))
{
successcount++;
_objMapping.SMSSentLog(companyCode, companyId, userCode, userName, senderCode, senderName, mobileno, message);
}
else
{
failurecount++;
failure += "<tr><td> " + userName + "</td><td>" + mobileno + "</td><td>Due to technical reasons unable to send SMS</td></tr>";
}
}
}
}
else
{
failure += "<tr><td>" + userName + "</td><td>" + mobileno + "</td><td>Mobile No. is invalid. Please update the correct mobile no. in employee master</td></tr>";
}
}
else
{
failure += "<tr><td>" + userName + "</td><td> </td><td>Mobile No. is empty. Please update the mobile no. in employee master</td></tr>";
}
}
if (failure != string.Empty)
{
sbTableContent.Append("<table id='error' class='table table-striped' >");
sbTableContent.Append("<thead class='active'>");
sbTableContent.Append("<tr style='background-color: #428bca'>");
sbTableContent.Append("<td class='errortable'>User Name</td>");
sbTableContent.Append("<td class='errortable'>Mobile Number</td>");
sbTableContent.Append("<td class='errortable'>Error</td>");
sbTableContent.Append("</tr>");
sbTableContent.Append("</thead>");
sbTableContent.Append(failure);
sbTableContent.Append("</table>");
mesgalert = "SMS sent for " + successcount + " user(s). Failed to send SMS for " + failurecount + "user(s)";
}
else
{
mesgalert = "SMS sent for " + successcount.ToString() + " user(s)";
}
return(sbTableContent.ToString() + "*" + mesgalert);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("Filter:UserCode", userCode);
dicContext.Add("Filter:CreatedDate", createdDate);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
return("Sorry an error occured. Please try again later.");
}
}
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.");
}
}
