public int Delete(int ID)
{
try
{
tblStudent tb = _db.tblStudents.Where(s => s.Student_Id == ID).FirstOrDefault();
_db.tblStudents.Remove(tb);
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public bool StudentAssignmentMatch(int?StudentId, int?RoutineId)
{
tblStudent ts = _db.tblStudents.Where(s => s.Student_Id == StudentId).FirstOrDefault();
tblAssignmentRoutine tr = _db.tblAssignmentRoutines.Where(r => r.Routine_Id == RoutineId).FirstOrDefault();
if (ts.Faculty_Id == tr.Faculty_Id && ts.YearBatchId == tr.YearBatchId /*&& ts.Section_Id == tr.Section_Id && ts.Semester_Id == tr.Semester_Id*/)
{
return(true);
}
else
{
return(false);
}
}
public int ChangePassword(int?studentid, ChangePasswordViewModel cvm)
{
try
{
tblStudent tb = _db.tblStudents.Where(s => s.Student_Id == studentid && 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())
{
tblStudent tb = db.tblStudents.Where(x => x.Student_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 = "Assignment Management System";
var studentname = 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!" + " " + studentname + " " + "Your Assignment Management System 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 ShiftStudentSemesterOrSection(ShiftStudentViewModel svm)
{
try
{
var shiftStudentList = _db.tblStudents.Where(s => s.YearBatchId == svm.Year_Batch_Id && s.Faculty_Id == svm.Faculty_Id && s.Semester_Id == svm.Semester_Id && s.Section_Id == svm.Section_Id).ToList();
//tblStudent tb = new tblStudent();
// tblStudent tb = _db.tblStudents.Where(s => s.Student_Id == svm.Id).FirstOrDefault();
foreach (var item in shiftStudentList)
{
tblStudent tb = _db.tblStudents.Where(s => s.Student_Id == item.Student_Id).FirstOrDefault();
tb.Section_Id = svm.ToSectionId;
tb.Semester_Id = svm.ToSemesterId;
_db.SaveChanges();
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(StudentViewModel svm)
{
try
{
tblStudent tb = _db.tblStudents.Where(s => s.Student_Id == svm.Id).FirstOrDefault();
tb.Name = svm.Name;
tb.Email = svm.Email;
tb.Password = tb.Password;
tb.Gender = svm.Gender;
tb.Phone = svm.Phone;
tb.Address = svm.Address;
tb.YearBatchId = svm.Year_Batch_Id;
tb.Faculty_Id = svm.Faculty_Id;
tb.Section_Id = svm.Section_Id;
tb.Semester_Id = svm.Semester_Id;
return(_db.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
