public async void Add <T>(T obj) { using SkipContext _db = new SkipContext(); await _db.AddAsync(obj); await _db.SaveChangesAsync(); }
// public async void Change(int Id, SReason obj) // { // using SkipContext _db = new SkipContext(); // SReason oldObj = _db.DbSet<SReason>().Find(Id); // if(oldObj != null){ // if(obj.Skip_Id != 0) oldObj.StudentId = obj.StudentId; // else if(obj.Img != null) oldObj.Img = obj.Img; // else if(obj.Count != 0) oldObj.Count = obj.Count; // else if(obj.Date != null) oldObj.Date = obj.Date; // } // await _db.SaveChangesAsync(); // } public async Task <int> Change <T>(int Id, T obj) where T : class { using (SkipContext _db = new SkipContext()) { var oldObj = _db.DbSet <T>().Find(Id); oldObj = obj; return(await _db.SaveChangesAsync()); } }
public async void setSkip(List <AddSkips> data, string month, int eduYear, int semester, int groupId) { Student[] students = (await _main.Where <Student>(e => e.GroupId == groupId)).OrderBy(e => e.Surname).ToArray(); using SkipContext _db = new SkipContext(); for (int i = 0; i < students.Count(); i++) { var report = _db.DbSet <Models.Report>() .First(e => e.StudentId == students[i].Id && e.EduYear == eduYear && e.Semester == semester && e.Month == month); report.Count += data[i].Count; _skip.Add(new SReason { Count = data[i].SReason, Date = DateTime.Now, Img = "", Skip_Id = report.Id }); await _db.SaveChangesAsync(); } }
public async void Remove <T>(T obj) { using SkipContext _db = new SkipContext(); _db.Remove(obj); await _db.SaveChangesAsync(); }