/// <summary>
/// This method used for user forgetpassword
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UserForgotPassword(ForgotPasswordModel model)
{
try
{
using (var context = new IOASDBEntities())
{
var userquery = context.tblUser.SingleOrDefault(dup => dup.Email == model.Email);
//if (userquery != null)
//{
// string temppass = userquery.Password;
// userquery.Password = Cryptography.Decrypt(temppass, "LFPassW0rd");
// if (userquery.Password != null)
// {
// model.password = userquery.Password;
// }
// //context.SaveChanges();
// //context.Dispose();
//}
if (userquery != null)
{
string temppass = Guid.NewGuid().ToString().Substring(0, 8);
userquery.Password = Cryptography.Encrypt(temppass, "LFPassW0rd");
var Disclaimer = EmailTemplate.disclaimer;
using (MailMessage mm = new MailMessage(EmailTemplate.mailid, model.Email))
{
mm.Subject = "IOAS Website Account Password";
string body = "Hello " + userquery.UserName + ",";
body += "<br /><br />Your account password has been reset successfully. Please use the below password to log into the system";
//body += "<br /><a href = '" + Request.Url.AbsoluteUri.Replace("Jobseekers.aspx", "CS_Activation.aspx?ActivationCode=" + activationCode) + "'>Click here to activate your account.</a>";
body += "<br />Your new password is " + temppass;
body += "<br /><br />Thanks";
body += "<br /><br />________________________________________________________________________________________________________________";
body += "<br /><br />*** This is an automatically generated email, please do not reply ***";
body += "<br /><br />" + Disclaimer;
mm.Body = body;
mm.IsBodyHtml = true;
using (SmtpClient smtp = new SmtpClient(EmailTemplate.smtpAddress, EmailTemplate.portNumber))
{
smtp.Credentials = new NetworkCredential(EmailTemplate.mailid, EmailTemplate.password);
//smtp.Credentials = new NetworkCredential("*****@*****.**", "ofni963");
//smtp.EnableSsl = EmailTemplate.enableSSL;
smtp.Send(mm);
}
}
context.SaveChanges();
context.Dispose();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(true);
}
}
/// <summary>
public static int UserRegistration(RegisterModel model)
{
try
{
using (var context = new IOASDBEntities())
{
using (var transaction = context.Database.BeginTransaction())
{
tblUserRole objuserrole = new tblUserRole();
if (model.UserId == 0)
{
try
{
tblUser reg = new tblUser();
var chkuser = context.tblUser.FirstOrDefault(dup => dup.UserName == model.Username && dup.Status == "Active");
if (chkuser != null)
{
return(2);
}
reg.FirstName = model.Firstname;
reg.LastName = model.Lastname;
reg.RoleId = model.RoleId;
reg.UserName = model.Username;
reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd");
reg.Dateofbirth = model.Dateofbirth;
reg.DepartmentId = model.Department;
reg.Gender = model.Gender;
reg.CRTDDateTS = DateTime.Now;
reg.UPDTDateTS = DateTime.Now;
string Username = model.Createuser;
reg.CreatedUserId = Common.GetUserid(Username);
reg.Email = model.Username;
reg.Status = "Active";
reg.UserImage = model.Image;
context.tblUser.Add(reg);
context.SaveChanges();
if (model.SelectedRoles != null)
{
var userid = (from U in context.tblUser
where (U.UserName == model.Username)
select U.UserId).FirstOrDefault();
model.UserId = userid;
for (int i = 0; i < model.SelectedRoles.Length; i++)
{
objuserrole.UserId = model.UserId;
objuserrole.RoleId = model.SelectedRoles[i];
objuserrole.Delegated_f = false;
context.tblUserRole.Add(objuserrole);
context.SaveChanges();
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
return(-1);
}
return(1);
}
else
{
var objupdateuser = context.tblUser.Where(U => U.UserId == model.UserId).FirstOrDefault();
if (objupdateuser != null)
{
try
{
objupdateuser.UserId = model.UserId;
objupdateuser.FirstName = model.Firstname;
objupdateuser.LastName = model.Lastname;
objupdateuser.RoleId = model.RoleId;
//bjupdateuser.UserName = model.Username;
//reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd");
objupdateuser.Dateofbirth = model.Dateofbirth;
objupdateuser.DepartmentId = model.Department;
objupdateuser.Gender = model.Gender;
objupdateuser.UPDTDateTS = DateTime.Now;
string Username = model.Createuser;
objupdateuser.LastUpdateUserId = Common.GetUserid(Username);
//objupdateuser.Email = model.Username;
if (model.Image != null)
{
objupdateuser.UserImage = model.Image;
}
context.SaveChanges();
var username = (from U in context.tblUser
where (U.UserId == model.UserId)
select U.UserName).FirstOrDefault();
model.Username = username;
var query = (from R in context.tblUserRole
where (R.UserId == model.UserId)
select R).ToList();
if (query.Count > 0)
{
context.tblUserRole.RemoveRange(query);
context.SaveChanges();
}
if (model.SelectedRoles != null)
{
for (int i = 0; i < model.SelectedRoles.Length; i++)
{
objuserrole.UserId = model.UserId;
objuserrole.RoleId = model.SelectedRoles[i];
objuserrole.Delegated_f = false;
context.tblUserRole.Add(objuserrole);
context.SaveChanges();
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
return(-1);
}
}
return(3);
}
}
}
}
catch (Exception ex)
{
return(-1);
}
}
