public bool GetPasswordReset(string password, Faculty facultyModel)
{
using (FacultyContext db = new FacultyContext())
{
try
{
if (facultyModel != null)
{
facultyModel.Password = password;
facultyModel.ModifiedDate = DateTime.Now;
db.Entry(facultyModel).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
}
public Faculty VerifyPasswordRecoveryDetails(Faculty facultyModel)
{
using (FacultyContext db = new FacultyContext())
{
var userId = db.Faculties.Where(s => s.SecurityQuestion == facultyModel.SecurityQuestion && s.SecurityQueAnswer == facultyModel.SecurityQueAnswer && s.UserId == facultyModel.UserId).FirstOrDefault();
return(userId);
}
}
public IEnumerable <Faculty> GetFacultyStatus()
{
using (FacultyContext db = new FacultyContext())
{
var facultyModel = db.Faculties.Where(s => s.RegistrationStatus == "Pending" && s.IsDeleted == false).ToList();
return(facultyModel);
}
}
public Faculty GetFacultyDetailsById(int id)
{
using (FacultyContext db = new FacultyContext())
{
var facultyModel = db.Faculties.Where(s => s.UserId == id).FirstOrDefault();
return(facultyModel);
}
}
public int GetFacultyId(Faculty facultyModel)
{
using (FacultyContext db = new FacultyContext())
{
var userId = db.Faculties.Where(s => s.SecurityQuestion == facultyModel.SecurityQuestion && s.SecurityQueAnswer == facultyModel.SecurityQueAnswer && (s.Contact == facultyModel.Contact || s.Email == facultyModel.Email)).Select(s => s.UserId).SingleOrDefault();
return(userId);
}
}
public IEnumerable <Faculty> GetFacultyDetails()
{
using (FacultyContext db = new FacultyContext())
{
var facultyModel = db.Faculties.Where(s => s.IsDeleted == false).ToList();
return(facultyModel);
}
}
public bool LoginCredentials(Faculty facultyModel)
{
using (FacultyContext db = new FacultyContext())
{
var status = db.Faculties.Where(s => s.UserId == facultyModel.UserId && s.Password == facultyModel.Password).FirstOrDefault();
if (status != null)
{
return(true);
}
else
{
return(false);
}
}
}
public bool EditFacultyDetails(Faculty faculty, string status, bool isdeleted)
{
using (FacultyContext db = new FacultyContext())
{
if (faculty != null)
{
faculty.RegistrationStatus = status;
faculty.IsDeleted = isdeleted;
db.Entry(faculty).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteFaculty(int id, Faculty faculty)
{
using (FacultyContext db = new FacultyContext())
{
var facultyModel = db.Faculties.Find(id);
if (facultyModel != null)
{
facultyModel.IsDeleted = true;
facultyModel.RegistrationStatus = "Rejected";
db.Entry(facultyModel).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public LoginController(FacultyContext context)
{
_context = context;
}
public TeachersController(FacultyContext context, IWebHostEnvironment hostEnvironment)
{
_context = context;
_webHostEnvironment = hostEnvironment;
}
public NicknameNameRepository(FacultyContext context)
{
this.db = context;
}
public TopicRepository(FacultyContext context)
{
this.db = context;
}
public HomeController(ILogger <HomeController> logger, FacultyContext context)
{
_logger = logger;
_context = context;
faceRecognitionHelper = new FaceRecognitionHelper(context);
}
public StudentsApiController(FacultyContext context)
{
_context = context;
}
public LearnerRepository(FacultyContext context)
{
this.db = context;
}
public EFUnitOfWork(string connectionString)
{
db = new FacultyContext(connectionString);
}
public LogRepository(FacultyContext context)
{
this.db = context;
}
public TeachersApiController(FacultyContext context)
{
_context = context;
}
public DetailsController(FacultyContext context)
{
_context = context;
}
public CoursesController(FacultyContext context)
{
_context = context;
}
public EnrollmentsApiController(FacultyContext context)
{
_context = context;
}
public FaceRecognitionHelper(FacultyContext context)
{
modelDirectory = Path.Combine(Environment.CurrentDirectory, @"FaceRecognitionModels");
_context = context;
}
public CourseRepository(FacultyContext context)
{
this.db = context;
}
public EnrollmentsController(FacultyContext context, IWebHostEnvironment webHostEnvironment)
{
_context = context;
_webHostEnvironment = webHostEnvironment;
}
public TeacherRepository(FacultyContext context)
{
this.db = context;
}