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 Add(TeacherViewModel tvm)
{
try
{
tblTeacher tb = new tblTeacher();
tb.Name = tvm.Name;
tb.Email = tvm.Email;
tb.Password = CreateRandomPassword(5);
tb.Phone = tvm.Phone;
tb.Address = tvm.Address;
_db.tblTeachers.Add(tb);
_db.SaveChanges();
tblMainLog tml = new tblMainLog();
var principal = System.Security.Claims.ClaimsPrincipal.Current;
string Name = principal.FindFirst(ClaimsIdentity.DefaultNameClaimType).Value;
str = "New Teacher Added With Name- '" + tvm.Name + "' " + ", Email- '" + tvm.Email + "' " + ", Phone- '" + tvm.Phone + "' " + "and Address- '" + tvm.Address + "Added by Admin";
tml.Description = str;
tml.AdminName = Name;
tml.Date = System.DateTime.Now;
tml.EntityId = 4;
tml.ItemId = tb.Teacher_Id;
_db.tblMainLogs.Add(tml);
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete(int ID)
{
try
{
tblTeacher tb = _db.tblTeachers.Where(t => t.Teacher_Id == ID).FirstOrDefault();
_db.tblTeachers.Remove(tb);
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int ChangePassword(int?teacherid, ChangePasswordViewModel cvm)
{
try
{
tblTeacher tb = _db.tblTeachers.Where(s => s.Teacher_Id == teacherid && s.Password == cvm.OldPassword).FirstOrDefault();
if (tb != null)
{
tb.Password = cvm.ConfirmNewPassword;
}
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public int SendEmail(int id)
{
using (AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities())
{
tblTeacher tb = db.tblTeachers.Where(x => x.Teacher_Id == id).FirstOrDefault();
try
{
if (tb != null)
{
var fromAddress = new MailAddress("*****@*****.**", "santoshmandal97788");
var toAddress = new MailAddress(tb.Email, "To Name");
const string fromPassword = "******";
const string subject = " ISMT COLLEGE Assignment Management System";
var teachername = tb.Name;
var Email = tb.Email;
var Password = tb.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!" + " " + teachername + " " + "Your Assignment Management System For Teacher Account is Created. And Your Login Credential is Email: " + Email + " " + "and Password: " + Password
})
{
smtp.Send(message);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(id);
}
}
public int Update(TeacherViewModel tvm)
{
try
{
tblTeacher tb = _db.tblTeachers.Where(t => t.Teacher_Id == tvm.Id).FirstOrDefault();
//var oldName = tb.Name;
//var oldEmail = tb.Email;
//var oldPhone = tb.Phone;
//var oldAddress = tb.Address;
List <string> lstchange = new List <string>();
if (tb.Name != tvm.Name)
{
lstchange.Add("name from " + tb.Name + " to " + tvm.Name);
}
if (tb.Email != tvm.Email)
{
lstchange.Add("email from " + tb.Email + " to " + tvm.Email);
}
if (tb.Phone != tvm.Phone)
{
lstchange.Add("phone from " + tb.Phone + " to " + tvm.Phone);
}
if (tb.Address != tvm.Address)
{
lstchange.Add("address from " + tb.Address + " to " + tvm.Address);
}
tb.Name = tvm.Name;
tb.Email = tvm.Email;
tb.Password = tb.Password;
tb.Phone = tvm.Phone;
tb.Address = tvm.Address;
//_db.SaveChanges();
if (lstchange.Count == 0)
{
return(_db.SaveChanges());
}
else
{
tblMainLog tml = new tblMainLog();
var principal = System.Security.Claims.ClaimsPrincipal.Current;
string Name = principal.FindFirst(ClaimsIdentity.DefaultNameClaimType).Value;
foreach (var item in lstchange)
{
str += item + ",";
}
string str2 = str;
tml.Description = str;
tml.AdminName = Name;
tml.Date = System.DateTime.Now;
tml.EntityId = 4;
tml.ItemId = tb.Teacher_Id;
_db.tblMainLogs.Add(tml);
return(_db.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
