public (bool IsError, string Message) SetValueWithResult(ChequeDTO cheque) { _db = new DbDataContext(); try { _db.Add(ChequeDTOExtention.ToModel(cheque)); _db.SaveChanges(); return(false, ""); } catch (Exception ex) { return(true, ex.Source); } finally { _db?.Dispose(); } }
public (bool IsError, string Message) DeleteValueByGuidWithResult(Guid guid) { _db = new DbDataContext(); try { _db.Remove(_db.Cheques.FirstOrDefault(p => p.Guid == guid)); _db.SaveChanges(); return(false, ""); } catch (Exception ex) { return(true, ex.Source); } finally { _db?.Dispose(); } }
public (bool IsError, string Message) DeleteValuesByDatesWithResult(double daysCount) { _db = new DbDataContext(); try { var values = _db.Cheques.Where(p => p.Date.AddDays(daysCount) >= DateTime.Today).ToList(); _db.RemoveRange(values); _db.SaveChanges(); return(false, ""); } catch (Exception ex) { return(true, ex.Source); } finally { _db?.Dispose(); } }