public void Add(SchoolDBModel schoolDBModel)
{
var school = ToMode(schoolDBModel);
using (JxxyContext jxxyContext = new JxxyContext())
{
jxxyContext.Schools.Add(school);
jxxyContext.SaveChanges();
}
}
public List<SchoolDBModel> GetSchools()
{
using (JxxyContext jxxyContext = new JxxyContext())
{
var dbSchools = (from school in jxxyContext.Schools
orderby school.CreatedDate descending
select school).ToList();
return FromModels(dbSchools);
}
}
public void Delete(string id)
{
using (JxxyContext jxxyContext = new JxxyContext())
{
var schoolDB = (from school in jxxyContext.Schools
where school.Id == id
select school).FirstOrDefault();
jxxyContext.Schools.Remove(schoolDB);
jxxyContext.SaveChanges();
}
}
public TeacherDBModel GetTeacher(string userName)
{
using (JxxyContext jxxyContext = new JxxyContext())
{
var dbTeacher = (from teacher in jxxyContext.Teachers
where teacher.LoginName == userName
select teacher).FirstOrDefault();
if(dbTeacher != null)
{
return FromMode(dbTeacher);
}
return null;
}
}
public SchoolDBModel GetSchoolById(string id)
{
using (JxxyContext jxxyContext = new JxxyContext())
{
var dbSchool = (from school in jxxyContext.Schools
where school.Id == id
select school).FirstOrDefault();
if (dbSchool != null)
{
return FromModel(dbSchool);
}
return null;
}
}
public void Update(SchoolDBModel schoolDBModel)
{
using (JxxyContext jxxyContext = new JxxyContext())
{
var schoolDB = (from school in jxxyContext.Schools
where school.Id == schoolDBModel.Id
select school).FirstOrDefault();
schoolDB.Name = schoolDBModel.Name;
schoolDB.Address = schoolDBModel.Address;
schoolDB.Remark = schoolDBModel.Remark;
schoolDB.UpdatedBy = schoolDBModel.UpdatedBy;
schoolDB.UpdatedDate = DateTime.Now;
jxxyContext.SaveChanges();
}
}
