/// <summary> /// Page Load functionality /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(Convert.ToString(Session["UserId"])) || !string.IsNullOrEmpty(Convert.ToString(Session["UserName"]))) { int userId = Convert.ToInt32(Session["UserId"]); LoginHistory objLoginLogoutHistory = new LoginHistory(); UserBLL objUserBLL = new UserBLL(); objLoginLogoutHistory.UserId = userId; objLoginLogoutHistory.LogoutTime = DateTime.Now; objLoginLogoutHistory.UpdatedBy = userId; objLoginLogoutHistory.UpdatedOn = DateTime.Now; objLoginLogoutHistory.UpdatedIp = CommonUtils.GetIPAddresses(); objLoginLogoutHistory.UserName = Convert.ToString(Session["UserName"]); objUserBLL.LogLogoutTime(objLoginLogoutHistory); ClearSession(); Response.Redirect("login.aspx"); } Response.Redirect("login.aspx"); } catch (Exception ex) { log.Error("Page_Load \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ Page_Load ", ex.Message + " \n " + ex.StackTrace); Response.Redirect("login.aspx"); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdLockedUsers_RowDataBound(object sender, GridViewRowEventArgs e) { try { GridView grdLockedUser = (GridView)sender; GridViewRow grdCurrentRow = e.Row; if (e.Row.RowType == DataControlRowType.DataRow) { string strPhysicianID = grdLockedUser.DataKeys[grdCurrentRow.RowIndex].Value.ToString(); ImageButton imgLock = (ImageButton)e.Row.FindControl("lnkLock"); imgLock.CommandArgument = DataBinder.Eval(e.Row.DataItem, "UserLogin.AccountLocked").ToString(); if (Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "UserLogin.AccountLocked"))) { imgLock.ImageUrl = "~/Style/Images/Lock.png"; imgLock.ToolTip = "UnLock User"; imgLock.Height = 24; imgLock.Width = 19; } else { imgLock.ImageUrl = "~/Style/Images/Unlock.png"; imgLock.ToolTip = "Lock User"; imgLock.Height = 24; imgLock.Width = 26; } } } catch (Exception ex) { log.Error("gvLockedUsers_RowDataBound \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ gvLockedUsers_RowDataBound ", ex.Message + " \n " + ex.StackTrace); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["Guid"])) { gudId = Convert.ToString(Request.QueryString["Guid"]); objAuditLog = objCommonBLL.GetAuditLogDetailsByGuid(gudId); if (objAuditLog != null) { if (objAuditLog.IsActive == true) { Response.Redirect(objAuditLog.PageName + "?Guid=" + gudId); } } } } } catch (Exception ex) { log.Error("Page_Load \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ Page_Load ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { if (Request.Cookies["UserName"] != null) { txtUserName.Text = Request.Cookies["UserName"].Value; } if (Request.Cookies["Password"] != null) { txtPassword.Attributes.Add("value", Request.Cookies["Password"].Value.ToString()); } if (Request.Cookies["UserName"] != null && Request.Cookies["Password"] != null) { chkRememberPassword.Checked = true; } else { chkRememberPassword.Checked = false; } } lblError.Attributes.Add("display", "none"); } catch (Exception ex) { log.Error("Page_Load \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ Page_Load ", ex.Message + " \n " + ex.StackTrace); } }
public ActionResult MyProfileImageUpload(HttpPostedFileBase UploadImage) { try { Images Image = new Images(); Image.BusinessID = BusinessId; Image.UserID = UserId; Image.UserTypeID = 2; var ImageName = Image.BusinessID + "-" + Image.UserTypeID + "-" + Image.UserID; string Extension = System.IO.Path.GetExtension(UploadImage.FileName); if (UploadImage.FileName != null) { Image.ImagePath = Image.BusinessID + "/" + Image.UserTypeID + "/" + Image.UserID + "/" + ImageName + Extension; } else { Image.ImagePath = ""; } return(RedirectToAction("MyProfile", new { id = UserId })); } catch (Exception ex) { ExceptionLog.WriteLog(ex, "Method:MyProfileImageUpload,Parameters: UploadImage=" + UploadImage); Elmah.ErrorSignal.FromCurrentContext().Raise(ex); return(null); } }
/// <summary> /// Method for clearing all fields. /// </summary> /// <param name="parent"></param> private void ClearAllFields(Control parent) { try { foreach (Control x in parent.Controls) { if ((x.GetType() == typeof(TextBox))) { ((TextBox)(x)).Text = ""; } if ((x.GetType() == typeof(DropDownList))) { ((DropDownList)(x)).SelectedValue = "0"; } if (x.HasControls()) { ClearAllFields(x); } } } catch (Exception ex) { log.Error("ClearAllFields \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ ClearAllFields ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Method for getting all country details /// </summary> /// <returns></returns> public List <Country> GetAllCountry() { List <Country> objLstCountry = new List <Country>(); try { using (DataSet SecurityQuestionTable = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.StoredProcedure, SP_GetAllCountry)) { if (SecurityQuestionTable.Tables[0].Rows.Count > 0) { for (int i = 0; i < SecurityQuestionTable.Tables[0].Rows.Count; i++) { Country objCountry = new Country(); objCountry.Id = Convert.ToInt32(SecurityQuestionTable.Tables[0].Rows[i]["Id"]); objCountry.CountryName = Convert.ToString(SecurityQuestionTable.Tables[0].Rows[i]["CountryName"]); objCountry.CreatedBy = Convert.ToInt32(SecurityQuestionTable.Tables[0].Rows[i]["CreatedBy"]); objCountry.CreatedOn = Convert.ToDateTime(SecurityQuestionTable.Tables[0].Rows[i]["CreatedOn"]); objCountry.UpdatedBy = Convert.ToInt32(SecurityQuestionTable.Tables[0].Rows[i]["UpdatedBy"]); objCountry.UpdatedOn = Convert.ToDateTime(SecurityQuestionTable.Tables[0].Rows[i]["UpdatedOn"]); objLstCountry.Add(objCountry); } } } } catch (Exception ex) { log.Error("GetAllCountry \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(COMMONDATA + " @ GetAllCountry ", ex.Message + " \n " + ex.StackTrace); } return(objLstCountry); }
/// <summary> /// Method for Getting audit log details /// </summary> /// <param name="GudId"></param> /// <returns></returns> public AuditLog GetAuditLogDetailsByGuid(string gudId) { AuditLog objAuditLog = new AuditLog(); try { SqlParameter objGudId = new SqlParameter("@GudId", SqlDbType.VarChar); objGudId.Value = gudId; using (DataSet AuditLogTable = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.StoredProcedure, SP_GetAuditLogDetailsByGuid, objGudId)) { if (AuditLogTable.Tables[0].Rows.Count > 0) { for (int i = 0; i < AuditLogTable.Tables[0].Rows.Count; i++) { objAuditLog.Id = Convert.ToInt32(AuditLogTable.Tables[0].Rows[i]["Id"]); objAuditLog.UserId = Convert.ToInt32(AuditLogTable.Tables[0].Rows[i]["UserId"]); //objAuditLog.GudId = Convert.ToString(AuditLogTable.Tables[0].Rows[i]["GudId"]); objAuditLog.CreatedBy = Convert.ToInt32(AuditLogTable.Tables[0].Rows[i]["CreatedBy"]); objAuditLog.CreatedOn = Convert.ToDateTime(AuditLogTable.Tables[0].Rows[i]["CreatedOn"]); objAuditLog.UpdatedBy = Convert.ToInt32(AuditLogTable.Tables[0].Rows[i]["UpdatedBy"]); objAuditLog.UpdatedOn = Convert.ToDateTime(AuditLogTable.Tables[0].Rows[i]["UpdatedOn"]); objAuditLog.PageName = Convert.ToString(AuditLogTable.Tables[0].Rows[i]["PageName"]); objAuditLog.IsActive = Convert.ToBoolean(AuditLogTable.Tables[0].Rows[i]["IsActive"]); } } } } catch (Exception ex) { log.Error("getAuditLogDetailsByGuid \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(COMMONDATA + " @ getAuditLogDetailsByGuid ", ex.Message + " \n " + ex.StackTrace); } return(objAuditLog); }
/// <summary> /// Method for getting all role /// </summary> /// <returns></returns> public List <Role> GetAllRoles() { List <Role> objLstRoles = new List <Role>(); try { using (DataSet RoleTable = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.StoredProcedure, SP_GetAllRoles)) { if (RoleTable.Tables[0].Rows.Count > 0) { for (int i = 0; i < RoleTable.Tables[0].Rows.Count; i++) { Role objRoles = new Role(); objRoles.Id = Convert.ToInt32(RoleTable.Tables[0].Rows[i]["Id"]); objRoles.RoleName = Convert.ToString(RoleTable.Tables[0].Rows[i]["RoleName"]); objRoles.IsActive = Convert.ToBoolean(RoleTable.Tables[0].Rows[i]["IsActive"]); objLstRoles.Add(objRoles); } } } } catch (Exception ex) { log.Error("GetAllRoles \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(COMMONDATA + " @ GetAllRoles ", ex.Message + " \n " + ex.StackTrace); } return(objLstRoles); }
/// <summary> /// Method for binding users to grid. /// </summary> /// <param name="searchUser"></param> private void BindUsers(string searchUser) { try { grdLockedUsers.ShowFooter = true; if (string.IsNullOrEmpty(searchUser)) { objListUsers = objUserBLL.GetUserDetails(); } else { // getting users based on search condition objListUsers = objUserBLL.GetSearchUserDetailsByUserName(searchUser); } if (objListUsers != null) { grdLockedUsers.DataSource = objListUsers; grdLockedUsers.DataBind(); if (objListUsers.Count > 10) { grdLockedUsers.ShowFooter = false; } } } catch (Exception ex) { log.Error("BindUsers \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ BindUsers ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Method for changing password. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnChangePassword_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(Request.QueryString["Guid"])) { GudId = Convert.ToString(Request.QueryString["Guid"]); objAuditLog = objCommonBLL.GetAuditLogDetailsByGuid(GudId); if (objAuditLog != null) { if (objAuditLog.IsActive == true) { objUserLogin.UserId = objAuditLog.UserId; objUserLogin.Password = CommonUtils.Encrypt(txtPassword.Text.Trim()); objUserLogin.UpdatedBy = Convert.ToInt32(Session["UserId"]); objUserLogin.UpdatedOn = DateTime.Now; objUserBLL.UpdatePassword(objUserLogin, GudId); Response.Redirect("Login.aspx"); } } } } catch (Exception ex) { log.Error("btnChangePassword_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ btnChangePassword_Click ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="UserId"></param> /// <param name="fName"></param> /// <param name="lName"></param> private void SendForgetPassword(int userId, string fName, string lName, string userName) { try { // Set SMTP Server Settings SmtpClient client = new SmtpClient(); client.DeliveryMethod = SmtpDeliveryMethod.Network; client.Host = Convert.ToString(CommonUtils.SMTPServerName); System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(Convert.ToString(CommonUtils.SMTPUserName), Convert.ToString(CommonUtils.SMTPPassword)); client.UseDefaultCredentials = false; client.Credentials = credentials; MailMessage objEmail = new MailMessage(); objEmail.From = new MailAddress(Convert.ToString(CommonUtils.EmailVerificationFrom)); objEmail.To.Add(new MailAddress(Convert.ToString(txtEmail.Text.Trim()))); objEmail.Subject = Convert.ToString(CommonUtils.ForgotPasswordSubject); objEmail.IsBodyHtml = true; objEmail.Body = Convert.ToString(CommonUtils.ForgotPasswordBody); objEmail.IsBodyHtml = true; objAuditLog.UserId = userId; objAuditLog.GudId = Guid.NewGuid(); objAuditLog.CreatedBy = Convert.ToInt32(Session["UserId"]); objAuditLog.CreatedOn = DateTime.Now; objAuditLog.UpdatedBy = Convert.ToInt32(Session["UserId"]); objAuditLog.UpdatedOn = DateTime.Now; objAuditLog.PageName = CommonUtils.ChangePasswordPage; objAuditLog.IsActive = true; objCommonBLL.AddAuditLog(objAuditLog); objEmail.Body = objEmail.Body.Replace("[NAME]", fName.Trim() + " " + lName.Trim()); objEmail.Body = objEmail.Body.Replace("[URL]", "http://" + HttpContext.Current.Request.Url.Host + HttpContext.Current.Request.ApplicationPath + "/" + CommonUtils.EmailLandingPage + "?Guid=" + objAuditLog.GudId); objEmail.Body = objEmail.Body.Replace("[UserName]", userName); objEmailLog.Subject = objEmail.Subject; objEmailLog.Body = objEmail.Body; objEmailLog.To = Convert.ToString(txtEmail.Text.Trim()); objEmailLog.From = Convert.ToString(CommonUtils.EmailVerificationFrom); objEmailLog.CreatedBy = Convert.ToInt32(Session["UserId"]); objEmailLog.CreatedOn = DateTime.Now; objCommonBLL.AddEmailLog(objEmailLog); try { client.Send(objEmail); } catch (Exception) { } lblErrorMsg.Text = "Please click the link sent to your registered email address."; } catch (Exception ex) { lblErrorMsg.Text = "Please click the link sent to your registered email address."; log.Error("SendForgetPassword \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ SendForgetPassword ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Method for sends verification email. /// </summary> /// <param name="UserId"></param> private void SendVerficationEmail(int UserId) { try { // Set SMTP Server Settings SmtpClient client = new SmtpClient(); client.DeliveryMethod = SmtpDeliveryMethod.Network; client.Host = Convert.ToString(CommonUtils.SMTPServerName); System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(Convert.ToString(CommonUtils.SMTPUserName), Convert.ToString(CommonUtils.SMTPPassword)); client.UseDefaultCredentials = false; client.Credentials = credentials; MailMessage objEmail = new MailMessage(); objEmail.From = new MailAddress(Convert.ToString(CommonUtils.EmailVerificationFrom)); objEmail.To.Add(new MailAddress(Convert.ToString(txtEmail.Text.Trim()))); objEmail.Subject = Convert.ToString(CommonUtils.EmailVerificationSubject); objEmail.IsBodyHtml = true; objEmail.Body = Convert.ToString(CommonUtils.EmailVerificationBody); objEmail.IsBodyHtml = true; objAuditLog.UserId = UserId; objAuditLog.GudId = Guid.NewGuid(); objAuditLog.CreatedBy = Convert.ToInt32(Session["UserId"]); objAuditLog.CreatedOn = DateTime.Now; objAuditLog.UpdatedBy = Convert.ToInt32(Session["UserId"]); objAuditLog.UpdatedOn = DateTime.Now; objAuditLog.PageName = CommonUtils.EmailVerificationSucessPage; objAuditLog.IsActive = true; objCommonBLL.AddAuditLog(objAuditLog); objEmail.Body = objEmail.Body.Replace("[NAME]", txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim()); objEmail.Body = objEmail.Body.Replace("[URL]", "http://" + HttpContext.Current.Request.Url.Host + HttpContext.Current.Request.ApplicationPath + "/" + CommonUtils.EmailLandingPage + "?Guid=" + objAuditLog.GudId); objEmail.Body = objEmail.Body.Replace("[UserName]", txtUserName.Text.Trim()); objEmailLog.Subject = objEmail.Subject; objEmailLog.Body = objEmail.Body; objEmailLog.To = Convert.ToString(txtEmail.Text.Trim()); objEmailLog.From = Convert.ToString(CommonUtils.EmailVerificationFrom); objEmailLog.CreatedBy = Convert.ToInt32(Session["UserId"]); objEmailLog.CreatedOn = DateTime.Now; objCommonBLL.AddEmailLog(objEmailLog); try { client.Send(objEmail); } catch (Exception ex) { throw ex; } } catch (Exception ex) { log.Error("SendEmailVerficationMail \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ SendEmailVerficationMail ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnLockedUsers_Click(object sender, EventArgs e) { try { BindUsers(txtUserName.Text.Trim()); } catch (Exception ex) { log.Error("btnLockedUsers_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ btnLockedUsers_Click ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void imgRefresh_Click(object sender, ImageClickEventArgs e) { try { imgCaptcha.ImageUrl = "~/CaptchaImage.ashx"; } catch (Exception ex) { log.Error("imgRefresh_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ imgRefresh_Click ", ex.Message + " \n " + ex.StackTrace); } }
public ActionResult ApproveLeave() { try { return(View()); } catch (Exception Ex) { ExceptionLog.WriteLog(Ex, "MethodName:ApproveLeave"); return(null); } }
/// <summary> /// Method for adding audit details /// </summary> /// <param name="objAuditLog"></param> /// <returns></returns> public int AddAuditLog(AuditLog objAuditLog) { int result = 0; try { SqlCommand objSqlCommand = new SqlCommand(); SqlParameter[] objLstParams = new SqlParameter[8]; SqlParameter objUserId = new SqlParameter("@UserId", SqlDbType.Int); objUserId.Value = objAuditLog.UserId; objLstParams[0] = objUserId; SqlParameter objGudId = new SqlParameter("@GudId", SqlDbType.VarChar); objGudId.Value = Convert.ToString(objAuditLog.GudId); objLstParams[1] = objGudId; SqlParameter objCreatedBy = new SqlParameter("@CreatedBy", SqlDbType.Int); objCreatedBy.Value = objAuditLog.CreatedBy; objLstParams[2] = objCreatedBy; SqlParameter objCreatedOn = new SqlParameter("@CreatedOn", SqlDbType.DateTime); objCreatedOn.Value = objAuditLog.CreatedOn; objLstParams[3] = objCreatedOn; SqlParameter objUpdatedBy = new SqlParameter("@UpdatedBy", SqlDbType.Int); objUpdatedBy.Value = objAuditLog.UpdatedBy; objLstParams[4] = objUpdatedBy; SqlParameter objUpdatedOn = new SqlParameter("@UpdatedOn", SqlDbType.DateTime); objUpdatedOn.Value = objAuditLog.UpdatedOn; objLstParams[5] = objUpdatedOn; SqlParameter objPageName = new SqlParameter("@PageName", SqlDbType.VarChar); objPageName.Value = objAuditLog.PageName; objLstParams[6] = objPageName; SqlParameter objIsActive = new SqlParameter("@IsActive", SqlDbType.Bit); objIsActive.Value = objAuditLog.IsActive; objLstParams[7] = objIsActive; result = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnectionString, CommandType.StoredProcedure, SP_AddAuditLog, objLstParams)); objSqlCommand.Parameters.Clear(); } catch (Exception ex) { log.Error("AddAuditLog \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(COMMONDATA + " @ AddAuditLog ", ex.Message + " \n " + ex.StackTrace); } return(result); }
/// <summary> /// /// </summary> /// <param name="userName"></param> /// <returns></returns> private bool DoesUserExist(string userName) { ExceptionLog.WriteLog(PageName + " @ Environment.UserDomainName", Environment.UserDomainName + " \n "); ExceptionLog.WriteLog(PageName + " @ userName", userName + " \n "); using (var domainContext = new PrincipalContext(ContextType.Domain, Environment.UserDomainName)) { using (var foundUser = UserPrincipal.FindByIdentity(domainContext, IdentityType.SamAccountName, userName)) { return(foundUser != null); } } }
/// <summary> /// Method for binding login history for given user. /// </summary> /// <param name="userName">user name</param> private void BindLoginHistory(string userName) { try { objListLoginHistory = objUserBLL.GetLoginHistory(userName); grdLoginHistory.DataSource = objListLoginHistory; grdLoginHistory.DataBind(); } catch (Exception ex) { log.Error("BindLoginHistory \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ BindLoginHistory ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnRegistration_Click(object sender, EventArgs e) { try { if (IsPostBack) { Page.Validate(); if (Page.IsValid) { objUser.FirstName = txtFirstName.Text.Trim(); objUser.LastName = txtLastName.Text.Trim(); objUser.Mobile = txtMobile.Text.Trim(); objUser.Email = txtEmail.Text.Trim(); objUser.Gender = Convert.ToInt32(rbnLstSex.SelectedValue.Trim()); objUser.Address = txtAddress.Text.Trim(); objUser.CountryId = Convert.ToInt32(ddlCountry.SelectedValue.Trim()); objUser.City = Convert.ToString(txtCity.Text.Trim()); objUser.ZipCode = Convert.ToString(txtZipCode.Text.Trim()); objUser.CreatedBy = Convert.ToInt32(Session["UserId"]); objUser.CreatedOn = DateTime.Now; objUser.UpdatedBy = Convert.ToInt32(Session["UserId"]); objUser.UpdatedOn = DateTime.Now; objUser.IsEmailVerified = false; objUserLogin.UserName = txtUserName.Text.Trim(); objUserLogin.Password = CommonUtils.Encrypt(txtPassword.Text.Trim()); objUserLogin.SecurityQuestion = Convert.ToInt32(ddlSecurityQuestion.SelectedValue.Trim()); objUserLogin.Answer = txtAnswer.Text.Trim(); objUserLogin.RoleId = Convert.ToInt32(ddlRole.SelectedValue.Trim()); objUserLogin.IsActive = false; objUserLogin.AccountLocked = false; objUser.UserLogin = objUserLogin; userId = objUserBLL.AddUserDetails(objUser); if (userId != 0) { SendVerficationEmail(userId); lblMsg.Text = "User registered sucessfully. Check your registered email for confirmation email."; lblMsg.ForeColor = Color.Green; lblMsg.Font.Bold = true; ClearAllFields(this); } } } } catch (Exception ex) { log.Error("btnRegistration_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ btnRegistration_Click ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { BindDefaultValues(); } } catch (Exception ex) { log.Error("Page_Load \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ Page_Load ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdLockedUsers_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Locked") { ImageButton lnkBtn = (ImageButton)e.CommandSource; GridViewRow grdCurrentRow = (GridViewRow)lnkBtn.Parent.Parent; GridView myGrid = (GridView)sender; int ID = Convert.ToInt32(myGrid.DataKeys[grdCurrentRow.RowIndex].Value.ToString()); if (Convert.ToBoolean(e.CommandArgument)) { Int32.TryParse(Convert.ToString(Session["UserId"]), out userId); User objUser = objUserBLL.GetUserDetailsById(userId); objUserLogin.AccountLocked = false; objUserLogin.PasswordWrongAttempts = 0; objUserLogin.UpdatedBy = objUser.Id; objUserLogin.UpdatedOn = DateTime.Now; objUserLogin.LastPasswordWrong = null; objUserLogin.UserId = ID; objUserBLL.UpdatePasswordWorngAttemptDetails(objUserLogin); } else { objLoginAttempts = objUserBLL.GetLoginAttempts(); if (objLoginAttempts != null && objLoginAttempts.Id > 0) { Int32.TryParse(Convert.ToString(Session["UserId"]), out userId); User objUser = objUserBLL.GetUserDetailsById(userId); objUserLogin.AccountLocked = true; objUserLogin.PasswordWrongAttempts = objLoginAttempts.LoginAttempt; objUserLogin.UpdatedBy = objUser.Id; objUserLogin.UpdatedOn = DateTime.Now; objUserLogin.LastPasswordWrong = DateTime.Now; objUserLogin.UserId = ID; objUserBLL.UpdatePasswordWorngAttemptDetails(objUserLogin); } } BindUsers(txtUserName.Text.Trim()); } } catch (Exception ex) { log.Error("gvLockedUsers_RowCommand \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ gvLockedUsers_RowCommand ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Method for adding email details in to email log /// </summary> /// <param name="objEmailLog"></param> /// <returns></returns> public int AddEmailLog(EmailLog objEmailLog) { int result = 0; try { SqlCommand objSqlCommand = new SqlCommand(); SqlParameter[] objLstParams = new SqlParameter[6]; SqlParameter objSubject = new SqlParameter("@Subject", SqlDbType.VarChar); objSubject.Value = objEmailLog.Subject; objLstParams[0] = objSubject; SqlParameter objBody = new SqlParameter("@Body", SqlDbType.VarChar); objBody.Value = Convert.ToString(objEmailLog.Body); objLstParams[1] = objBody; SqlParameter objTo = new SqlParameter("@To", SqlDbType.VarChar); objTo.Value = objEmailLog.To; objLstParams[2] = objTo; SqlParameter objFrom = new SqlParameter("@From", SqlDbType.VarChar); objFrom.Value = objEmailLog.From; objLstParams[3] = objFrom; SqlParameter objCreatedBy = new SqlParameter("@CreatedBy", SqlDbType.Int); objCreatedBy.Value = objEmailLog.CreatedBy; objLstParams[4] = objCreatedBy; SqlParameter objCreatedOn = new SqlParameter("@CreatedOn", SqlDbType.DateTime); objCreatedOn.Value = objEmailLog.CreatedOn; objLstParams[5] = objCreatedOn; result = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnectionString, CommandType.StoredProcedure, SP_AddEmailLog, objLstParams)); objSqlCommand.Parameters.Clear(); } catch (Exception ex) { log.Error("AddEmailLog \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(COMMONDATA + " @ AddEmailLog ", ex.Message + " \n " + ex.StackTrace); } return(result); }
/// <summary> /// Method for Validating Captcha. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ValidateCaptcha(object sender, ServerValidateEventArgs e) { try { e.IsValid = false; if (!string.IsNullOrEmpty(txtCaptcha.Text) && !string.IsNullOrEmpty(Convert.ToString(Session["CaptchaImageText"]))) { if (Convert.ToString(Session["CaptchaImageText"]) == txtCaptcha.Text.Trim()) { e.IsValid = true; } } } catch (Exception ex) { log.Error("ValidateCaptcha \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ ValidateCaptcha ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Page Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Convert.ToString(Session["UserId"]))) { userId = Convert.ToInt32(Session["UserId"]); } BindUsers(string.Empty); } } catch (Exception ex) { log.Error("Page_Load \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ Page_Load ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> private void BindDefaultValues() { try { var Countries = objCommonBLL.GetAllCountry(); if (Countries != null) { ddlCountry.DataSource = Countries; ddlCountry.DataValueField = "Id"; ddlCountry.DataTextField = "CountryName"; ddlCountry.DataBind(); } ddlCountry.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); var Questions = objCommonBLL.GetAllSecurityQuestion(); if (Questions != null) { ddlSecurityQuestion.DataSource = Questions; ddlSecurityQuestion.DataValueField = "Id"; ddlSecurityQuestion.DataTextField = "QuestionName"; ddlSecurityQuestion.DataBind(); } ddlSecurityQuestion.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); var Roles = objCommonBLL.GetAllRoles(); if (Roles != null) { ddlRole.DataSource = Roles; ddlRole.DataValueField = "Id"; ddlRole.DataTextField = "RoleName"; ddlRole.DataBind(); } ddlRole.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); } catch (Exception ex) { log.Error("BindDefaultValues \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ BindDefaultValues ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtLoginAttempts.Text)) { objLoginAttempts.LoginAttempt = Convert.ToInt32(txtLoginAttempts.Text.Trim()); objLoginAttempts.UpdatedBy = Convert.ToInt32(Session["UserId"]); objLoginAttempts.UpdatedOn = DateTime.Now; objLoginAttempts.UpdatedIp = Convert.ToString(CommonUtils.GetIPAddresses()); objUserBLL.UpdateLoginAttempts(objLoginAttempts); lblMsg.Visible = true; lblMsg.Text = "Login attempts updated sucessfully."; lblMsg.ForeColor = Color.Green; } } catch (Exception ex) { log.Error("btnSave_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ btnSave_Click ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnChangePassword_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtPassword.Text.Trim()) && !string.IsNullOrEmpty(txtNewPassword.Text.Trim()) && !string.IsNullOrEmpty(txtNewConfirmPassword.Text.Trim())) { userId = Convert.ToInt32(Session["UserId"]); User objUser = objUserBLL.GetUserDetailsById(userId); if (objUser.Id != 0) { if (CommonUtils.Encrypt(txtPassword.Text).Equals(objUser.UserLogin.Password)) { objUserLogin.Password = CommonUtils.Encrypt(txtNewPassword.Text); objUserLogin.UpdatedBy = userId; objUserLogin.UserId = userId; objUserLogin.UpdatedOn = DateTime.Now; objUserBLL.UpdateUserPassword(objUserLogin); lblError.Text = "Password updated successfully."; lblError.Visible = true; cvNewPassword.Visible = false; lblError.ForeColor = Color.Green; } else { lblError.ForeColor = Color.Red; lblError.Text = "Password does not match."; lblError.Visible = true; cvNewPassword.Visible = true; } } } } catch (Exception ex) { log.Error("btnChangePassword_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ btnChangePassword_Click ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Page Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { objLoginAttempts = objUserBLL.GetLoginAttempts(); txtLoginAttempts.Text = "0"; if (objLoginAttempts != null) { if (objLoginAttempts.Id > 0) { txtLoginAttempts.Text = Convert.ToString(objLoginAttempts.LoginAttempt); } } } } catch (Exception ex) { log.Error("Page_Load \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ Page_Load ", ex.Message + " \n " + ex.StackTrace); } }
/// <summary> /// Used for sending email /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSendMail_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtEmail.Text.Trim())) { objUser = objUserBLL.GetUserDetailsByEmailId(txtEmail.Text.Trim()); if (objUser != null) { if (objUser.Id != 0) { if (objUser.IsEmailVerified == true) { SendForgetPassword(objUser.Id, objUser.FirstName, objUser.LastName, objUser.UserLogin.UserName); } else { lblErrorMsg.Text = "Email address is not verified, Please click the link sent to your registered email address."; } } else { lblErrorMsg.Text = "No account found with that email address."; } } else { lblErrorMsg.Text = "No account found with that email address."; } } } catch (Exception ex) { log.Error("btnSendMail_Click \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace); ExceptionLog.WriteLog(PageName + " @ btnSendMail_Click ", ex.Message + " \n " + ex.StackTrace); } }