public List <MVCModels.HiDoctor_Master.WeekendGroup> GetWeekendGroupHeader() { string companyCode = _objCurInfo.GetCompanyCode(); List <MVCModels.HiDoctor_Master.WeekendGroup> lstWeekendGroup = new List <MVCModels.HiDoctor_Master.WeekendGroup>(); try { _objData.OpenConnection(companyCode); { using (sqldataReader = _objData.ExecuteReader("" + EXEC + " " + SP_HDGETWEEKENDGROUPNAME + " '" + companyCode + "'")) { while (sqldataReader.Read()) { MVCModels.HiDoctor_Master.WeekendGroup objWeekendGroup = new MVCModels.HiDoctor_Master.WeekendGroup(); objWeekendGroup.Weekend_Off_Code = sqldataReader["Weekend_Off_Code"].ToString(); objWeekendGroup.Weekend_Off_Name = sqldataReader["Weekend_Off_Name"].ToString(); lstWeekendGroup.Add(objWeekendGroup); } } } } catch { throw; } finally { _objData.CloseConnection(); } return(lstWeekendGroup); }
public bool InsertMappedRegions(DataTable dtRegCodes, string UserName) { bool result = false; try { SqlCommand command = new SqlCommand("SP_HD_InsertMappedRegion"); command.CommandType = CommandType.StoredProcedure; //using (IDbConnection connection = IDbOpenConnection()) //{ // var p = new DynamicParameters(); // p.Add("@UserName", UserName); // result=connection.Execute(SP_HD_InsertMappedRegion, p, commandType: CommandType.StoredProcedure); // connection.Close(); //} if (dtRegCodes.Rows.Count == 0) { _objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_DCRStatus_RegionCodes", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_DCRStatus_RegionCodes"); } else { _objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_DCRStatus_RegionCodes", ParameterDirection.Input, SqlDbType.Structured, dtRegCodes, "TVP_DCRStatus_RegionCodes"); } _objData.OpenConnection(); _objData.ExecuteNonQuery(command); result = true; } catch (Exception ex) { throw; } return(result); }
//Fill DDL Division , Region-Type , Region-Classification , User-Type , Expense-Header-Group #region Get ExpenseMapping Master Data public DataSet GetExpenseMappingMasterData() { DataSet ds = new DataSet(); objData.OpenConnection(_ObjCurInfo.GetCompanyCode()); { string StrSQL = "EXEC SP_hdGetExpenseMappingMasterData " + _ObjCurInfo.GetCompanyCode(); ds = objData.ExecuteDataSet(StrSQL); objData.CloseConnection(); } return(ds); }
public bool CheckSfcMasterExist() { try { bool flag = false; DataControl.CurrentInfo objCurr = new DataControl.CurrentInfo(); DataControl.Data objData = new DataControl.Data(); string companyCode = objCurr.GetCompanyCode(); string regionCode = objCurr.GetRegionCode(); int result = 0; objData.OpenConnection(companyCode); { result = Convert.ToInt32(objData.ExecuteScalar("exec SP_hdCheckSfcMasterExist '" + companyCode + "','" + regionCode + "'")); } objData.CloseConnection(); if (result > 0) { flag = true; } return(flag); } catch (Exception ex) { throw ex; } }
public bool InsertUserSession() { DataControl.Data objData = new DataControl.Data(); try { string macId = GetMACInformation(); string ipAddress = Request.ServerVariables["REMOTE_ADDR"].ToString(); string browserName = Request.Browser.Browser + " " + Request.Browser.MajorVersion.ToString() + "." + Request.Browser.MinorVersion.ToString(); string companyCode = _objCurInfo.GetCompanyCode(); string userCode = _objCurInfo.GetUserCode(); string userName = _objCurInfo.GetUserName(); string sessionId = _objCurInfo.GetSessionId(); string latitude = _objCurInfo.GetLattitude(); string longitude = _objCurInfo.GetLongitude(); string location = _objCurInfo.GetLocation(); string loginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff"); bool isTrue = false; objData.OpenConnection(_objCurInfo.GetCompanyCode()); { objData.ExecuteNonQuery("exec sp_sdInsertUserSession '" + _objCurInfo.GetCompanyCode() + "','" + _objCurInfo.GetUserCode() + "','" + _objCurInfo.GetUserName() + "','" + _objCurInfo.GetSessionId() + "','" + loginTime + "','" + ipAddress + "','" + macId + "','" + browserName + "','" + latitude + "','" + longitude + "','" + location + "'"); } return(isTrue); } finally { objData.CloseConnection(); } }
public bool InsertMasterData(DataTable dtUserCodes) { bool result = false; try { SqlCommand command = new SqlCommand("SP_HD_InsertMasterData"); command.CommandType = CommandType.StoredProcedure; if (dtUserCodes.Rows.Count == 0) { _objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_MasterData_Details", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_MasterData_Details"); } else { _objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_MasterData_Details", ParameterDirection.Input, SqlDbType.Structured, dtUserCodes, "TVP_MasterData_Details"); } _objData.OpenConnection(); _objData.ExecuteNonQuery(command); result = true; } catch (Exception ex) { throw; } return(result); }
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 int InsertSplashScreenData(string companyCode, SplashScreenModel objSplashScreenModel) { int result = 0; try { SqlCommand command = new SqlCommand(SP_SC_INSERT_SPLASH_SCREEN_DATA); command.CommandType = CommandType.StoredProcedure; _objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode); _objSPData.AddParamToSqlCommand(command, "@Splash_Type", ParameterDirection.Input, SqlDbType.VarChar, 150, objSplashScreenModel.Splash_Type); _objSPData.AddParamToSqlCommand(command, "@Title", ParameterDirection.Input, SqlDbType.VarChar, 150, objSplashScreenModel.Title); _objSPData.AddParamToSqlCommand(command, "@Description", ParameterDirection.Input, SqlDbType.VarChar, 1000, objSplashScreenModel.Description); _objSPData.AddParamToSqlCommand(command, "@File_Path", ParameterDirection.Input, SqlDbType.VarChar, 250, objSplashScreenModel.File_Path); _objSPData.AddParamToSqlCommand(command, "@Date_From", ParameterDirection.Input, SqlDbType.Date, 30, objSplashScreenModel.Date_From); _objSPData.AddParamToSqlCommand(command, "@Date_To", ParameterDirection.Input, SqlDbType.Date, 30, objSplashScreenModel.Date_To); _objSPData.AddParamToSqlCommand(command, "@Has_Attachment", ParameterDirection.Input, SqlDbType.Int, 4, objSplashScreenModel.Has_Attachment); _objSPData.AddParamToSqlCommand(command, "@Mobile_Attachment_Url", ParameterDirection.Input, SqlDbType.VarChar, 250, objSplashScreenModel.Mobile_Attachment_Url); _objSPData.AddParamToSqlCommand(command, "@Assigned_To_All_Users", ParameterDirection.Input, SqlDbType.Int, 4, objSplashScreenModel.Assigned_To_All_Users); _objSPData.AddParamToSqlCommand(command, "@Is_Completed", ParameterDirection.Input, SqlDbType.Int, 4, objSplashScreenModel.Is_Completed); _objSPData.AddParamToSqlCommand(command, "@Last_Modified_DateTime", ParameterDirection.Input, SqlDbType.DateTime, 20, objSplashScreenModel.Last_Modified_DateTime); _objSPData.AddParamToSqlCommand(command, "@Description_HTML", ParameterDirection.Input, SqlDbType.VarChar, -1, objSplashScreenModel.Description_HTML); SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.Int); returnValue.Direction = ParameterDirection.Output; returnValue.Size = 500; returnValue.Value = ""; command.Parameters.Add(returnValue); _objData.OpenConnection(companyCode); _objData.ExecuteNonQuery(command); result = Convert.ToInt32(returnValue.Value); return(result); } catch (Exception ex) { throw ex; } finally { _objData.CloseConnection(); } }
public DataSet GetAllExpense() { DataSet dssub = new DataSet(); objData.OpenConnection(objCurrentInfo.GetCompanyCode()); { string StrSQL = "EXEC SP_hd_ExpenseType_Select " + objCurrentInfo.GetCompanyCode(); dssub = objData.ExecuteDataSet(StrSQL); objData.CloseConnection(); } return(dssub); }
public string ExpenseInsert(string storedProcedure, string expensetypeCode, string companyCode, string expensetypeName, string expensetypeStatus, string expenseMode, string Period, string Mode, string displayOrder) { try { DataControl.CurrentInfo objCurentInfo = new DataControl.CurrentInfo(); //string conStr = objData.GetConnectionString(objCurentInfo.GetCompanyCode()); //con.ConnectionString = conStr; DataControl.Data db = new DataControl.Data(); // Command - specify as StoredProcedure SqlCommand command = new SqlCommand(storedProcedure, con); command.CommandType = CommandType.StoredProcedure; AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode); AddParamToSqlCommand(command, "@Expense_Type_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, expensetypeCode); AddParamToSqlCommand(command, "@Expense_Type_Name", ParameterDirection.Input, SqlDbType.VarChar, 50, expensetypeName); AddParamToSqlCommand(command, "@Expense_Type_Status", ParameterDirection.Input, SqlDbType.VarChar, 30, expensetypeStatus); AddParamToSqlCommand(command, "@Expense_Mode", ParameterDirection.Input, SqlDbType.VarChar, 30, expenseMode); AddParamToSqlCommand(command, "@Expense_Period", ParameterDirection.Input, SqlDbType.VarChar, 30, Period); AddParamToSqlCommand(command, "@Mode", ParameterDirection.Input, SqlDbType.VarChar, 30, Mode); AddParamToSqlCommand(command, "@DisplayOrder", ParameterDirection.Input, SqlDbType.VarChar, 30, displayOrder); // Return value as parameter SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar); returnValue.Direction = ParameterDirection.Output; returnValue.Size = 500; command.Parameters.Add(returnValue); if (db.OpenConnection(objCurentInfo.GetCompanyCode())) { // Execute the stored procedure db.ExecuteNonQuery(command); db.CloseConnection(); } //For Handle the Error return(returnValue.Value.ToString()); } catch (Exception ex) { ErrorLog.LogError(ex, "ExpenseInsert()"); return("ERROR"); } }
public string Inward(string storedProcedure, string companyCode, string UserCode, string ProductCode, string InwardDate, string Inwardstock, string UserInwardCode, string UserInwarddetails, string CurrentStock) { try { DataControl.CurrentInfo objCurentInfo = new DataControl.CurrentInfo(); //string conStr = objData.GetConnectionString(objCurentInfo.GetCompanyCode()); //con.ConnectionString = conStr; DataControl.Data db = new DataControl.Data(); // Command - specify as StoredProcedure SqlCommand command = new SqlCommand(storedProcedure, con); command.CommandType = CommandType.StoredProcedure; AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode); AddParamToSqlCommand(command, "@User_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, UserCode); AddParamToSqlCommand(command, "@Product_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, ProductCode); AddParamToSqlCommand(command, "@Inward_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, InwardDate); AddParamToSqlCommand(command, "@Inward_stock", ParameterDirection.Input, SqlDbType.VarChar, 30, Inwardstock); AddParamToSqlCommand(command, "@User_Inward_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, UserInwardCode); AddParamToSqlCommand(command, "@User_Inward_Detail", ParameterDirection.Input, SqlDbType.VarChar, 30, UserInwarddetails); AddParamToSqlCommand(command, "@Current_Stock", ParameterDirection.Input, SqlDbType.VarChar, 30, CurrentStock); // Return value as parameter SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar); returnValue.Direction = ParameterDirection.Output; returnValue.Size = 500; command.Parameters.Add(returnValue); if (db.OpenConnection(objCurentInfo.GetCompanyCode())) { // Execute the stored procedure db.ExecuteNonQuery(command); db.CloseConnection(); } //For Handle the Error return(returnValue.Value.ToString()); } catch (Exception ex) { ErrorLog.LogError(ex, "Inward()"); return("ERROR"); } }
public string productInsert(string storedProcedure, string companyCode, string salesproductCode, string mappingproductCode, string effectiveFrom, string createdDate, string createdBy, string recordStatus) { try { DataControl.CurrentInfo objCurentInfo = new DataControl.CurrentInfo(); //string conStr = objData.GetConnectionString(objCurentInfo.GetCompanyCode()); //con.ConnectionString = conStr; DataControl.Data db = new DataControl.Data(); // Command - specify as StoredProcedure SqlCommand command = new SqlCommand(storedProcedure, con); command.CommandType = CommandType.StoredProcedure; AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode); AddParamToSqlCommand(command, "@Sales_Product_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, salesproductCode); AddParamToSqlCommand(command, "@Mapping_Product_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, mappingproductCode); AddParamToSqlCommand(command, "@Effective_From", ParameterDirection.Input, SqlDbType.VarChar, 30, effectiveFrom); AddParamToSqlCommand(command, "@Created_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, createdDate); AddParamToSqlCommand(command, "@Created_By", ParameterDirection.Input, SqlDbType.VarChar, 30, createdBy); AddParamToSqlCommand(command, "@Record_Status", ParameterDirection.Input, SqlDbType.VarChar, 1, recordStatus); // Return value as parameter SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar); returnValue.Direction = ParameterDirection.Output; returnValue.Size = 500; command.Parameters.Add(returnValue); if (db.OpenConnection(objCurentInfo.GetCompanyCode())) { // Execute the stored procedure db.ExecuteNonQuery(command); db.CloseConnection(); } //For Handle the Error return(returnValue.Value.ToString()); } catch (Exception ex) { ErrorLog.LogError(ex, "productInsert()"); return("ERROR"); } }
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 List <Models.MasterModel> UserDetails(string userCode, string companyCode) { try { List <Models.MasterModel> lstUserDetail = new List <Models.MasterModel>(); _objData.OpenConnection(companyCode); using (IDataReader reader = _objData.ExecuteReader("exec SP_hdGetTpVsActualDeviationSummary '" + companyCode + "', '" + userCode + "','','','USER'")) { lstUserDetail = DataReaderMapToList <Models.MasterModel>(reader); } _objData.CloseConnection(); return(lstUserDetail); } catch (Exception ex) { throw ex; } finally { _objData.CloseConnection(); } }
public double CalculateSFCFare(Models.FareCalculationDTO fareCalcPassed) { try { double totalFare = 0.0; string hopNeed = fareCalcPassed.IntermediatePlace; string entity = fareCalcPassed.Entity; string dcrCode = fareCalcPassed.DcrCode; string dcrDate = fareCalcPassed.DcrDate; string dcrFlag = fareCalcPassed.DcrFalg; Controllers.MasterController objMaster = new Controllers.MasterController(); DataControl.CurrentInfo objCurr = new DataControl.CurrentInfo(); DataControl.Data objData = new DataControl.Data(); string companyCode = objCurr.GetCompanyCode(); string userCode = objCurr.GetUserCode(); string regionCode = objCurr.GetRegionCode(); if (entity == "HQ") { DataSet dsHop = new DataSet(); objData.OpenConnection(companyCode); { dsHop = objData.ExecuteDataSet("exec SP_hdGetHopPlaces '" + companyCode + "','" + dcrCode + "','" + userCode + "','" + dcrDate + "','" + dcrFlag + "'"); } objData.CloseConnection(); if (dsHop.Tables[0].Rows.Count > 0) { try { objData.OpenConnection(companyCode); { totalFare = Convert.ToDouble(objData.ExecuteScalar("exec SP_hdGetSFCAmount '" + companyCode + "','" + dsHop.Tables[0].Rows[0]["SFC_Region_Code"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["From_Place"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["To_Place"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["SFC_Category_Name"].ToString().Trim() + "','" + dsHop.Tables[0].Rows[0]["Travel_Mode"].ToString().Trim() + "','" + dcrDate + "','" + userCode + "','" + regionCode + "','" + entity + "'")); } objData.CloseConnection(); } catch { totalFare = 0.0; } } } else { DataSet dsTravelPlace = new DataSet(); double fareAmount = 0.0; double travelDistance = 0.0; dsTravelPlace = objMaster.GetTrvelPlace(companyCode, dcrCode, dcrFlag, userCode, dcrDate); if (dsTravelPlace.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsTravelPlace.Tables[0].Rows) { travelDistance = Convert.ToDouble(dr["Distance"].ToString().Trim()); try { objData.OpenConnection(companyCode); { fareAmount = Convert.ToDouble(objData.ExecuteScalar("exec SP_hdGetSFCAmount '" + companyCode + "','" + dr["SFC_Region_Code"].ToString().Trim() + "','" + dr["From_Place"].ToString().Trim() + "','" + dr["To_Place"].ToString().Trim() + "','" + dr["SFC_Category_Name"].ToString().Trim() + "','" + dr["Travel_Mode"].ToString().Trim() + "','" + dcrDate + "','" + userCode + "','" + regionCode + "','" + entity + "'")); } objData.CloseConnection(); } catch { fareAmount = 0.0; } totalFare += fareAmount; } } } return(totalFare); } catch (Exception ex) { throw ex; } }
public string GetLogin(FormCollection collection) { try { //System.Web.HttpContext.Current.Session["Comp_Code"] = null; bool isTrue; //= _objCurInfo.SetCompanyCode(); //if (!isTrue) //{ // return "FAILURE:Unable to open database"; //} string companyCode = _objCurInfo.GetCompanyCode(); string userName = collection["userName"].ToString(); string password = collection["password"].ToString(); string userCode = string.Empty; string privValue = string.Empty; string commonPassword = _objCurInfo.GetCommonPassword(); string errMsg = string.Empty; string isCaseSensitive = "0"; isTrue = false; DataSet dsPrivilege = new DataSet(); DataSet dsUserInfo = new DataSet(); _latitude = collection["latitude"].ToString(); _longitude = collection["longitude"].ToString(); _sourceOfEntry = collection["sourceOfEntry"].ToString(); if (_data.OpenConnection(companyCode)) { dsPrivilege = _objData.GetPrivilegeData(companyCode, userName); _data.CloseConnection(); } if (dsPrivilege != null && dsPrivilege.Tables.Count > 0) { _objCurInfo.SetPrivilegeValues(dsPrivilege); privValue = _objCurInfo.GetPrivilegeValue("PASSWORD_POLICY", "NO"); if (privValue == "YES") // Password policy privilege is enabled { privValue = _objCurInfo.GetPrivilegeValue("PASSWORD_STRENGTH", "WEAK"); if (privValue == "GOOD" || privValue == "STRONG" || privValue == "VERY_STRONG") { isCaseSensitive = "1"; // Password should be case sensitive } } dsUserInfo = _objData.CheckUserAuthentication(companyCode, userName, password, commonPassword, isCaseSensitive); privValue = _objCurInfo.GetPrivilegeValue("PASSWORD_POLICY", "NO"); if (privValue == "YES") // Password policy privilege is enabled { if (dsUserInfo != null && dsUserInfo.Tables.Count > 0 && dsUserInfo.Tables[0].Rows.Count > 0) // Valid username password { userCode = dsUserInfo.Tables[0].Rows[0]["User_Code"].ToString().Trim(); if (dsUserInfo.Tables[0].Rows[0]["Status"].ToString().Trim().ToUpper() == USER_STATUS_VALID) { isTrue = IsAccountLocked(dsUserInfo); if (isTrue) // Account is locked { errMsg = ReleaseUserAccount(companyCode, userCode, dsUserInfo); // Account is released after the grace period if (errMsg == string.Empty) { errMsg = RedirectToPage(companyCode, "YES", userCode, dsUserInfo); } else { return(errMsg); // Still account is locked } } else { errMsg = RedirectToPage(companyCode, "YES", userCode, dsUserInfo); // Account is not locked } } else { errMsg = LockUserAccount(companyCode, userCode, dsUserInfo); // Lock user account return(errMsg); } } else { errMsg = "Invalid username or password"; return(errMsg); } } else { if (dsUserInfo != null && dsUserInfo.Tables.Count > 0 && dsUserInfo.Tables[0].Rows.Count > 0) // Valid username password { if (dsUserInfo.Tables[0].Rows[0]["Status"].ToString().Trim().ToUpper() == "VALID") { userCode = dsUserInfo.Tables[0].Rows[0]["User_Code"].ToString(); errMsg = RedirectToPage(companyCode, "NO", userCode, dsUserInfo); } else { errMsg = "Invalid username or password"; return(errMsg); } } else { errMsg = "Invalid username or password"; } } } else { errMsg = "Invalid username or password"; } return(errMsg); } catch (Exception ex) { return(ex.Message); } }
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"); } }