public void SaveCategory(Category cat)
{
using (FinViewModel fvm = new FinViewModel())
{
fvm.Categorys.Add(cat);
fvm.SaveChanges();
}
}
public void SaveTransactions(List <Transactions> listTransaction)
{
using (FinViewModel fvm = new FinViewModel())
{
fvm.Transactions.AddOrUpdate(listTransaction.ToArray());
fvm.SaveChanges();
}
}
public void RemoveCategory(Category cat)
{
using (FinViewModel fvm = new FinViewModel())
{
fvm.Categorys.Attach(cat);
fvm.Categorys.Remove(cat);
fvm.SaveChanges();
}
}
public Transactions GetTransaction(params object[] keyValues)
{
Transactions res = null;
using (FinViewModel fvm = new FinViewModel())
{
res = fvm.Transactions.Find(keyValues);
}
return(res);
}
public List <Category> GetCategories()
{
List <Category> res;
using (FinViewModel fvm = new FinViewModel())
{
res = fvm.Set <Category>().ToList();
}
return(res);
}
public List <Transactions> GetTransaction()
{
List <Transactions> res;
using (FinViewModel fvm = new FinViewModel())
{
res = fvm.Set <Transactions>()
.ToList();
}
return(res);
}
public List <Transactions> GetTransaction(DateTime fromDate, DateTime toDate)
{
List <Transactions> res;
using (FinViewModel fvm = new FinViewModel())
{
res = fvm.Set <Transactions>()
.Where(t => t.TransactionDate >= fromDate.Date && t.TransactionDate <= toDate.Date)
.OrderBy(o => o.TransactionDate)
.ToList();
}
return(res);
}
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();
}
}
