public Student Edit(Student entity)
{
try
{
using (var db = new ManagerContext())
{
db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(entity);
}
public Student Add(Student entity)
{
try
{
using (var db = new ManagerContext())
{
db.Students.Add(entity);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(entity);
}
public Pwd Remove(Pwd entity)
{
try
{
using (var db = new ManagerContext())
{
db.Pwds.Remove(entity);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(entity);
}
public int GetCampusId()
{
int CampusId = (new Student()).CampusId;
try
{
using (var db = new ManagerContext())
{
CampusId = db.Students.ToList().Count == 0 ? CampusId : db.Students.Max(f => f.CampusId) + 1;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(CampusId);
}
public Student Find(int CampusId)
{
Student pwd = null;
try
{
using (var db = new ManagerContext())
{
pwd = db.Students?.FirstOrDefault(f => f.CampusId == CampusId);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(pwd);
}
public Pwd Find(int id)
{
Pwd pwd = null;
try
{
using (var db = new ManagerContext())
{
pwd = db.Pwds?.FirstOrDefault(f => f.Id == id) as Pwd;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(pwd);
}
public IEnumerable <Student> FindAll(string fullname = null)
{
IEnumerable <Student> students = null;
try
{
using (var db = new ManagerContext())
{
fullname = fullname ?? "";
students = db.Students?.ToList().Where(f => f.Fullname.Trim().ToLower().Contains(fullname.Trim().ToLower()));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(students);
}
public IEnumerable <Pwd> FindAll(string title = null)
{
IEnumerable <Pwd> Pwds = null;
try
{
using (var db = new ManagerContext())
{
title = title ?? "";
Pwds = db.Pwds?.ToList().Where(f => f.Title.Trim().ToLower().Contains(title.Trim().ToLower()));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(Pwds);
}
