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