public int SendRecoveryPasswordEMail(ForgetPasswordViewModel fpvm)
{
using (AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities())
{
tblStudent tb = db.tblStudents.Where(s => s.Email == fpvm.Email).FirstOrDefault();
tblTeacher tb1 = db.tblTeachers.Where(t => t.Email == fpvm.Email).FirstOrDefault();
tblAdmin tb2 = db.tblAdmins.Where(a => a.Email == fpvm.Email).FirstOrDefault();
try
{
string password = "";
if (tb != null)
{
password = tb.Password;
}
else if (tb1 != null)
{
password = tb1.Password;
}
else
{
password = tb2.Password;
}
if (tb != null || tb1 != null || tb2 != null)
{
var fromAddress = new MailAddress("*****@*****.**", "santoshmandal97788");
var toAddress = new MailAddress(fpvm.Email, "To Name");
const string fromPassword = "******";
const string subject = "Assignment Management System Password Recovery:";
var sendpwd = password;
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = "Hi!" + "Your Assignment Management System Password is: " + sendpwd
})
{
smtp.Send(message);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(0);
}
}
public int Delete(int ID)
{
try
{
tblAdmin tb = _db.tblAdmins.Where(a => a.Admin_Id == ID).FirstOrDefault();
_db.tblAdmins.Remove(tb);
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(Admin adm)
{
try
{
tblAdmin tb = _db.tblAdmins.Where(a => a.Admin_Id == adm.Admin_Id).FirstOrDefault();
tb.Name = adm.Name;
tb.Email = adm.Email;
tb.Password = adm.Password;
tb.Role = adm.Role;
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int Add(Admin adm)
{
try
{
tblAdmin tb = new tblAdmin();
tb.Name = adm.Name;
tb.Email = adm.Email;
tb.Password = adm.Password;
tb.Role = adm.Role;
_db.tblAdmins.Add(tb);
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
