public void SaveTransactions(List <Transactions> listTransaction) { using (FinViewModel fvm = new FinViewModel()) { fvm.Transactions.AddOrUpdate(listTransaction.ToArray()); fvm.SaveChanges(); } }
public void SaveCategory(Category cat) { using (FinViewModel fvm = new FinViewModel()) { fvm.Categorys.Add(cat); fvm.SaveChanges(); } }
public void RemoveCategory(Category cat) { using (FinViewModel fvm = new FinViewModel()) { fvm.Categorys.Attach(cat); fvm.Categorys.Remove(cat); fvm.SaveChanges(); } }
public FileUploadTrack InitiateImport() { FileUploadTrack fut = new FileUploadTrack(); using (FinViewModel fvm = new FinViewModel()) { fut.Status = ImportStatus.Inprogress; fut.UploadDate = DateTime.Now; fvm.Set <FileUploadTrack>().Add(fut); fvm.SaveChanges(); } return(fut); }
public void SaveTransactions(Transactions tran) { using (FinViewModel fvm = new FinViewModel()) { if (tran.posted_at == null) { fvm.Transactions.Add(tran); } else { if (fvm.Entry(tran).State == System.Data.Entity.EntityState.Detached) { fvm.Set <Transactions>().Attach(tran); fvm.Entry(tran).State = System.Data.Entity.EntityState.Modified; } } var ss = fvm.SaveChanges(); } }
public void SaveFileUploadTrack(FileUploadTrack fut) { using (FinViewModel fvm = new FinViewModel()) { if (fut.Id == 0) { fvm.Set <FileUploadTrack>().Add(fut); } else { if (fvm.Entry(fut).State == System.Data.Entity.EntityState.Detached) { fvm.Set <FileUploadTrack>().Attach(fut); } } fut.Status = ImportStatus.Uploaded; fvm.SaveChanges(); } }