protected void btnSave_Click(object sender, EventArgs e)
{
if (Session["UserID"] != null)
{
SEC_UserDAL dalSEC_User = new SEC_UserDAL();
SEC_UserENT entSEC_User = new SEC_UserENT();
SEC_UserBAL balSEC_User = new SEC_UserBAL();
DataTable dt = dalSEC_User.CheckPassword(Convert.ToInt32(Session["UserID"]), Convert.ToString(Session["UserName"]), txtOldPassword.Text.Trim());
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
entSEC_User.UserID = Convert.ToInt32(dr["UserID"]);
entSEC_User.UserName = dr["UserName"].ToString();
entSEC_User.Password = txtNewPassword.Text.Trim();
entSEC_User.Email = Convert.ToString(dr["Email"]);
entSEC_User.CreationDate = DateTime.Now;
entSEC_User.ModificationDate = DateTime.Now;
balSEC_User.Update(entSEC_User);
pnlAlert.Visible = true;
lblErrorMsg.Text = "Password Successfully Changed.";
//ucMessage.ShowSuccess("Password Successfully Changed.");
}
}
else
{
lblOldPassword.Text = "Old Password is wrong.";
}
}
else
{
Response.Redirect("~/Login/Login.aspx");
}
}
public Boolean Update(SEC_UserENT entSEC_User)
{
SEC_UserDAL dalSEC_User = new SEC_UserDAL();
if (dalSEC_User.Update(entSEC_User))
{
return(true);
}
else
{
this.Message = dalSEC_User.Message;
return(false);
}
}
public Boolean Insert(SEC_UserENT entSEC_User)
{
try
{
SqlDatabase sqlDB = new SqlDatabase(myConnectionString);
DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_SEC_User_Insert");
sqlDB.AddInParameter(dbCMD, "@UserName", SqlDbType.VarChar, entSEC_User.UserName);
sqlDB.AddInParameter(dbCMD, "@Password", SqlDbType.VarChar, entSEC_User.Password);
sqlDB.AddInParameter(dbCMD, "@Email", SqlDbType.VarChar, entSEC_User.Email);
sqlDB.AddInParameter(dbCMD, "@CreationDate", SqlDbType.DateTime, entSEC_User.CreationDate);
sqlDB.AddInParameter(dbCMD, "@ModificationDate", SqlDbType.DateTime, entSEC_User.ModificationDate);
DataBaseHelper DBH = new DataBaseHelper();
DBH.ExecuteNonQuery(sqlDB, dbCMD);
//entSEC_User.UserID = (SqlInt32)Convert.ToInt32(dbCMD.Parameters["@UserID"].Value);
return(true);
}
catch (SqlException sqlex)
{
Message = SQLDataExceptionMessage(sqlex);
if (SQLDataExceptionHandler(sqlex))
{
throw;
}
return(false);
}
catch (Exception ex)
{
Message = ExceptionMessage(ex);
if (ExceptionHandler(ex))
{
throw;
}
return(false);
}
}
protected void lbtnSignup_Click(object sender, EventArgs e)
{
Page.Validate();
if (Page.IsValid)
{
try
{
SEC_UserBAL balSEC_User = new SEC_UserBAL();
SEC_UserENT entSEC_User = new SEC_UserENT();
#region 15.1 Validate Fields
String ErrorMsg = String.Empty;
if (txtUserName.Text.Trim() == String.Empty)
{
ErrorMsg += " - UserName is Required Field <br />";
}
if (txtPassword.Text.Trim() == String.Empty)
{
ErrorMsg += " - Password is Required Field <br />";
}
if (txtEmail.Text.Trim() == String.Empty)
{
ErrorMsg += " - Email is Required Field <br />";
}
if (ErrorMsg != String.Empty)
{
ErrorMsg = "Please Correct follwing error <br />" + ErrorMsg;
lblErrorMsg.Text = ErrorMsg;
return;
}
#endregion
#region FillData
if (txtUserName.Text.Trim() != String.Empty)
{
entSEC_User.UserName = txtUserName.Text.Trim();
}
if (txtPassword.Text.Trim() != String.Empty)
{
entSEC_User.Password = txtPassword.Text.Trim();
}
if (txtEmail.Text.Trim() != String.Empty)
{
entSEC_User.Email = txtEmail.Text.Trim();
}
entSEC_User.CreationDate = DateTime.Now;
entSEC_User.ModificationDate = DateTime.Now;
#endregion FillData
if (CheckDuplicate(txtUserName.Text.Trim(), txtEmail.Text.Trim()))
{
#region 15.3 Insert
if (balSEC_User.Insert(entSEC_User))
{
pnlErrorMsg.Visible = true;
lblErrorMsg.Text = "SignUP Successfully";
ClearControls();
//Response.Redirect("~/AdminPanel/Login.aspx");
}
#endregion 15.3 Insert
}
else
{
pnlErrorMsg.Visible = true;
lblErrorMsg.Text = "User OR Email Already Exists.";
}
}
catch (Exception ex)
{
pnlErrorMsg.Visible = true;
lblErrorMsg.Text = ex.Message;
}
}
}
public SEC_UserENT SelectPK(SqlInt32 UserID)
{
try
{
SqlDatabase sqlDB = new SqlDatabase(myConnectionString);
DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_SEC_User_SelectByPK");
sqlDB.AddInParameter(dbCMD, "@UserID", SqlDbType.Int, UserID);
SEC_UserENT entSEC_User = new SEC_UserENT();
DataBaseHelper DBH = new DataBaseHelper();
using (IDataReader dr = DBH.ExecuteReader(sqlDB, dbCMD))
{
while (dr.Read())
{
if (!dr["UserID"].Equals(System.DBNull.Value))
{
entSEC_User.UserID = Convert.ToInt32(dr["UserID"]);
}
if (!dr["UserName"].Equals(System.DBNull.Value))
{
entSEC_User.UserName = Convert.ToString(dr["UserName"]);
}
if (!dr["Password"].Equals(System.DBNull.Value))
{
entSEC_User.Password = Convert.ToString(dr["Password"]);
}
if (!dr["Email"].Equals(System.DBNull.Value))
{
entSEC_User.Email = Convert.ToString(dr["Email"]);
}
if (!dr["CreationDate"].Equals(System.DBNull.Value))
{
entSEC_User.CreationDate = Convert.ToDateTime(dr["CreationDate"]);
}
if (!dr["ModificationDate"].Equals(System.DBNull.Value))
{
entSEC_User.ModificationDate = Convert.ToDateTime(dr["ModificationDate"]);
}
}
}
return(entSEC_User);
}
catch (SqlException sqlex)
{
Message = SQLDataExceptionMessage(sqlex);
if (SQLDataExceptionHandler(sqlex))
{
throw;
}
return(null);
}
catch (Exception ex)
{
Message = ExceptionMessage(ex);
if (ExceptionHandler(ex))
{
throw;
}
return(null);
}
}
