protected void btnSave_Click(object sender, EventArgs e)
{
this.ClearMessagePanel();
if (IsValid())
{
using (MSIPortalContext ctx = new MSIPortalContext())
{
try
{
// Setup User
tbl_User user = new tbl_User();
user.UserID = Guid.NewGuid();
user.LoginName = txtEmail.Text.Trim();
user.FirstName = txtFirstName.Text.Trim();
user.LastName = txtLastName.Text.Trim();
user.RoleID = ddlUserType.SelectedValue;
user.CityID = ddlCity.SelectedValue;
user.IsActive = true;
user.EditUser = ((tbl_User)Session["User"]).UserID;
user.EditDate = DateTime.Now;
//Setup Password
tbl_UserPassword pass = new tbl_UserPassword();
pass.UserID = user.UserID;
pass.Password = txtPassword.Text.Trim();
pass.EditUser = ((tbl_User)Session["User"]).UserID;
pass.EditDate = DateTime.Now;
ctx.tbl_User.Add(user);
ctx.tbl_UserPassword.Add(pass);
ctx.SaveChanges();
this.ClearForm();
lblSuccessMessage.Text = "User created successfully.";
lblErrorMessage.Text = string.Empty;
MessagePanel.Visible = true;
txtEmail.Focus();
this.BindGrid();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.Write("Property: {0} Error: {1}" + validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (Exception Ex)
{
}// End of Catch
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtEmail.Text.Trim() == string.Empty)
{
lblSuccessMessage.Text = "Email required";
return;
}
string password = string.Empty;
using (MSIPortalContext ctx = new MSIPortalContext())
{
var result = from p in ctx.tbl_UserPassword where p.tbl_User.LoginName == txtEmail.Text.Trim() select p;
tbl_UserPassword tblPassword = result.FirstOrDefault <tbl_UserPassword>();
if (tblPassword != null)
{
password = tblPassword.Password;
}
}
if (password != string.Empty)
{
try
{
var client = new SmtpClient("smtp.gmail.com", 587)
{
Credentials = new NetworkCredential("*****@*****.**", "posting2014"),
EnableSsl = true
};
client.Send("*****@*****.**", txtEmail.Text.Trim(), "Password Recovery", "Your Lost password: "******"Your password has been sent to your email.";
txtEmail.Text = string.Empty;
txtEmail.Focus();
lblErrorMessage.Text = string.Empty;
}
catch (Exception ex)
{
lblErrorMessage.Text = "Error occured.";
lblSuccessMessage.Text = string.Empty;
}
}
else
{
lblErrorMessage.Text = "Email does not exist.";
lblSuccessMessage.Text = string.Empty;
}
}
private void FillAboutYouSecttion(tbl_User user)
{
tbl_UserPassword pass = FindPasswordByUserId(user.UserID).FirstOrDefault <tbl_UserPassword>();
txtUserEmail.Text = user.LoginName.Trim();
txtPassword.Text = pass.Password.Trim();
txtConfirmPassword.Text = pass.Password.Trim();
txtUserFirstlName.Text = user.FirstName.Trim();
txtUserLastName.Text = user.LastName.Trim();
ddlUserLocation.SelectedValue = user.CityID.Trim();
//Disable Controls
txtUserEmail.Enabled = false;
txtPassword.Enabled = false;
txtConfirmPassword.Enabled = false;
txtUserFirstlName.Enabled = false;
txtUserLastName.Enabled = false;
ddlUserLocation.Enabled = false;
lblUserEmailValidation.Text = string.Empty;
}
protected void btnUpdatePassword_Click(object sender, EventArgs e)
{
tbl_User user = (tbl_User)Session["User"];
using (MSIPortalContext ctx = new MSIPortalContext())
{
var pass = from p in ctx.tbl_UserPassword
where p.Password == txtExistingPassword.Text.Trim() && p.tbl_User.LoginName == user.LoginName
select p;
tbl_UserPassword password = pass.FirstOrDefault <tbl_UserPassword>();
if (password != null)
{
if (txtNewPassword.Text.Trim() == txtConfirmNewPassword.Text.Trim())
{
password.Password = txtNewPassword.Text.Trim();
ctx.Entry(password).State = EntityState.Modified;
ctx.SaveChanges();
txtExistingPassword.Text = string.Empty;
txtNewPassword.Text = string.Empty;
txtConfirmNewPassword.Text = string.Empty;
cpSuccessMessage.Text = "Password changed successfully";
cpErrorMessage.Text = string.Empty;
txtExistingPassword.Focus();
}
else
{
cpSuccessMessage.Text = string.Empty;
cpErrorMessage.Text = "New password and confirm new password miss match.";
}
}
else
{
cpSuccessMessage.Text = string.Empty;
cpErrorMessage.Text = "Provided password does not exist.";
}
}
}
private void SavePost()
{
ClearMessagePanel();
using (MSIPortalContext ctx = new MSIPortalContext())
{
try
{
tbl_Post post = new tbl_Post();
tbl_User user = new tbl_User();
tbl_UserPassword password = new tbl_UserPassword();
//===========Initialize the User Table
if (Session["User"] != null)
{
user = (tbl_User)Session["User"];
}
else if (FindUserByEmailAndPassword().Count > 0)
{
user = FindUserByEmailAndPassword().FirstOrDefault <tbl_User>();
}
else if (FindUserByEmailAndPassword().Count == 0) // If Existing User but not Logged In [Eaml&Password Count May be 0]
{
if (FindUserByEmailOnly().Count == 0) // Insert only if this email is completely new [Email count may be greater than 0]
{
//Set User
user = new tbl_User();
user.UserID = Guid.NewGuid();
user.LoginName = this.txtUserEmail.Text.Trim();
user.FirstName = this.txtUserFirstlName.Text.Trim();
user.LastName = this.txtUserLastName.Text.Trim();
user.RoleID = "02"; // Ordinary User
user.CityID = ddlUserLocation.SelectedValue;
user.IsActive = true;
user.EditUser = user.UserID;
user.EditDate = DateTime.Now;
//Set Password
password.UserID = user.UserID;
password.Password = txtPassword.Text.Trim();
password.EditUser = user.UserID;
password.EditDate = DateTime.Now;
//Add to Context
ctx.tbl_User.Add(user);
ctx.tbl_UserPassword.Add(password);
}
else
{
MessagePanel.Visible = true;
txtUserEmail.Focus();
lblUserEmailValidation.Text = "*";
lblErrorMessage.Text = "Already registered email";
lblSuccessMessage.Visible = false;
return; // Stop Inserting any Single Record
}
}
//============Initialize Post Table
post.PostID = Guid.NewGuid();
post.CategoryID = ddlCategory.SelectedValue;
post.CityID = ddlCommonCity.SelectedValue;
if (rdoCommonSales.Checked)
{
post.PSTID = "001";
}
else
{
post.PSTID = "002";
}
post.PostTitle = this.txtCommonPostingTitle.Text.Trim();
post.PostDescription = this.txtCommonPostingDescription.Text.Trim();
if (commonImageUpload.PostedFile.FileName != string.Empty)
{
commonImageUpload.SaveAs(Server.MapPath("~/imageupload/" + post.PostID + ".jpg"));
post.ImageUrl = "/imageupload/" + post.PostID + ".jpg";
}
else
{
post.ImageUrl = "/Styles/images/" + "no_image.jpg";
}
post.PostingUserID = user.UserID;
post.ProviderFirstName = txtCommonProviderFirstName.Text.Trim();
post.ProviderLastName = txtCommonProviderLastName.Text.Trim();
post.ProviderAddress = txtCommonProviderAddress.Text.Trim();
post.ProviderEmail = txtCommonProviderEmil.Text.Trim();
post.ProviderPhoneNo = txtCommonProviderPhone.Text.Trim();
post.Approved = false;
post.Rank = 999; // Default value to make sure out of rank
post.EditUser = user.UserID;
post.EditDate = DateTime.Now;
ctx.tbl_Post.Add(post);
ctx.SaveChanges();
//---------------After Successful Save Do the following operation
MessagePanel.Visible = true;
lblSuccessMessage.Visible = true;
lblSuccessMessage.Text = "Your posting is successful!";
//this.SendConfirmationEmail();
lblUserEmailValidation.Text = string.Empty;
this.ClearForm();
ddlCommonCountry.Focus();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.Write("Property: {0} Error: {1}" + validationError.PropertyName, validationError.ErrorMessage);
}
}
}
catch (Exception Ex)
{
Response.Write(Ex.ToString());
} // End of Catch
} // End of Using
}
