public async void Add <T>(T obj) { using SkipContext _db = new SkipContext(); await _db.AddAsync(obj); await _db.SaveChangesAsync(); }
public async Task <T> First <T>() where T : class { using SkipContext _db = new SkipContext(); T result = _db.DbSet <T>().FirstOrDefault(); return(await Task.Run(() => result)); }
public async Task <T[]> Where <T>(Func <T, bool> predicate) where T : class { using SkipContext _db = new SkipContext(); IEnumerable <T> result = _db.DbSet <T>().Where(predicate); return(await Task.Run(() => result.ToArray())); }
// 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 int GetExceptionCount(SkipContext skipContext) { return _db.ExecuteQuery(cmd => { cmd.CommandText = "Select Count(*) from BatchStepException where StepName = @StepName and JobName = @JobName"; cmd.Parameters.AddWithValue("@StepName", skipContext.StepName); cmd.Parameters.AddWithValue("@JobName", _jobName); return (int) cmd.ExecuteScalar(); }); }
public int GetExceptionCount(SkipContext skipContext) { return(_db.ExecuteQuery(cmd => { cmd.CommandText = "Select Count(*) from BatchStepException where StepName = @StepName and JobName = @JobName"; cmd.Parameters.AddWithValue("@StepName", skipContext.StepName); cmd.Parameters.AddWithValue("@JobName", _jobName); return (int)cmd.ExecuteScalar(); })); }
public void SaveExceptionInfo(SkipContext skipContext, int exceptionCount) { const string insert = "Insert into BatchStepException (StepIndex, StepName, JobName, ExceptionMsg, ExceptionDetails) " + "Values (@StepIndex, @StepName, @JobName, @ExMsg, @ExDetails)"; _db.ExecuteQuery(cmd => { cmd.CommandText = insert; cmd.Parameters.AddWithValue("@StepIndex", skipContext.StepIndex); cmd.Parameters.AddWithValue("@StepName", skipContext.StepName); cmd.Parameters.AddWithValue("@JobName", _jobName); cmd.Parameters.AddWithValue("@ExMsg", skipContext.Exception.Message); cmd.Parameters.AddWithValue("@ExDetails", skipContext.Exception.StackTrace); return(cmd.ExecuteNonQuery()); }); }
public SkipContext skip() { SkipContext _localctx = new SkipContext(Context, State); EnterRule(_localctx, 12, RULE_skip); try { EnterOuterAlt(_localctx, 1); { State = 79; Match(INT); } } catch (RecognitionException re) { _localctx.exception = re; ErrorHandler.ReportError(this, re); ErrorHandler.Recover(this, re); } finally { ExitRule(); } return(_localctx); }
public async void setSReason(string path, int studentId, string month, int count) { Student student = await _main.GetById <Student>(studentId); Group group = await _main.GetById <Group>(student.GroupId); using SkipContext _db = new SkipContext(); Models.Report value = _db.DbSet <Models.Report>() .First(e => e.EduYear == group.Course && e.Month == month && e.StudentId == studentId); _skip.Add( new SReason { Count = count, Date = DateTime.Now, Img = path, Skip_Id = value.Id } ); }
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(); } }
private static async Task _enumerate(AsyncEnumerator <TSource> .Yield yield, SkipContext <TSource> context) { try { var itemsToSkip = context.Count; while (await context.Source.MoveNextAsync(yield.CancellationToken).ConfigureAwait(false)) { if (itemsToSkip > 0) { itemsToSkip--; } else { await yield.ReturnAsync(context.Source.Current).ConfigureAwait(false); } } } finally { if (context.DisposeSource) { context.Source.Dispose(); } } }
public void SaveExceptionInfo(SkipContext skipContext, int currentCount) { ++_exceptionCount; Console.WriteLine("Skippable exception on line: {0} - {1}", skipContext.StepIndex, skipContext.Exception.Message); }
public async void Remove <T>(T obj) { using SkipContext _db = new SkipContext(); _db.Remove(obj); await _db.SaveChangesAsync(); }
public int GetExceptionCount(SkipContext context) { return _exceptionCount; }
public void SaveExceptionInfo(SkipContext skipContext, int exceptionCount) { const string insert = "Insert into BatchStepException (StepIndex, StepName, JobName, ExceptionMsg, ExceptionDetails) " + "Values (@StepIndex, @StepName, @JobName, @ExMsg, @ExDetails)"; _db.ExecuteQuery(cmd => { cmd.CommandText = insert; cmd.Parameters.AddWithValue("@StepIndex", skipContext.StepIndex); cmd.Parameters.AddWithValue("@StepName", skipContext.StepName); cmd.Parameters.AddWithValue("@JobName", _jobName); cmd.Parameters.AddWithValue("@ExMsg", skipContext.Exception.Message); cmd.Parameters.AddWithValue("@ExDetails", skipContext.Exception.StackTrace); return cmd.ExecuteNonQuery(); }); }
private static async Task _enumerate(AsyncEnumerator <TSource> .Yield yield, SkipContext <TSource> context) { using (var enumerator = await context.Source.GetAsyncEnumeratorAsync(yield.CancellationToken).ConfigureAwait(false)) { var itemsToSkip = context.Count; while (await enumerator.MoveNextAsync(yield.CancellationToken).ConfigureAwait(false)) { if (itemsToSkip > 0) { itemsToSkip--; } else { await yield.ReturnAsync(enumerator.Current).ConfigureAwait(false); } } } }
public async Task <T[]> Get <T>() where T : class { using SkipContext _db = new SkipContext(); return(await Task.Run(() => _db.DbSet <T>().ToArray())); }
public async Task <T> GetById <T>(int Id) where T : class { using SkipContext _db = new SkipContext(); return(await Task.Run(() => _db.DbSet <T>().Find(Id))); }
public int GetExceptionCount(SkipContext context) { return(_exceptionCount); }