public void Add(SchoolDBModel schoolDBModel)
{
var school = ToMode(schoolDBModel);
using (JxxyContext jxxyContext = new JxxyContext())
{
jxxyContext.Schools.Add(school);
jxxyContext.SaveChanges();
}
}
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();
}
}
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();
}
}