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