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();
}
