public override IList<Category> GetCategories(string user)
{
var context = new MoneyBoxEntities();
var list =
context.tblMoneyBox_Categories.Where(item => item.CreatedBy == user).OrderBy(item => item.Name).ToList();
return Convert(list);
}
public override IList<Record> GetRecords(int categoryId)
{
var context = new MoneyBoxEntities();
var list =
context.tblMoneyBox_Records.Where(item => item.CategoryId == categoryId).OrderByDescending(item => item.Date).
ToList();
return Convert(list);
}
public override IList<Record> GetRecords(string user)
{
var context = new MoneyBoxEntities();
var list =
context.tblMoneyBox_Records.Where(item => item.CreatedBy == user).OrderByDescending(item => item.Date).
ToList();
return Convert(list);
}
public override void DeleteRecord(int id)
{
var context = new MoneyBoxEntities();
var obj = new tblMoneyBox_Records {Id = id};
context.AttachTo("tblMoneyBox_Records", obj);
context.DeleteObject(obj);
context.SaveChanges();
}
public override int InsertCategory(Category category)
{
var context = new MoneyBoxEntities();
var obj = new tblMoneyBox_Categories();
category.CopyToObject(obj);
context.AddTotblMoneyBox_Categories(obj);
context.SaveChanges();
return obj.Id;
}
public override IList<Record> GetRecords(string user, int indexOfPage, int sizeOfPage, out int total)
{
var context = new MoneyBoxEntities();
total = context.tblMoneyBox_Records.Where(item => item.CreatedBy == user).Count();
var list =
context.tblMoneyBox_Records.Where(item => item.CreatedBy == user).OrderByDescending(item => item.Date).
Skip(indexOfPage*sizeOfPage).Take(sizeOfPage).ToList();
return Convert(list);
}
public override void UpdateCategory(Category category)
{
var context = new MoneyBoxEntities();
var obj = new tblMoneyBox_Categories {Id = category.Id};
context.AttachTo("tblMoneyBox_Categories", obj);
category.CopyToObject(obj);
context.SaveChanges();
}
public override int InsertRecord(Record record)
{
var context = new MoneyBoxEntities();
var obj = new tblMoneyBox_Records();
record.CopyToObject(obj);
context.AddTotblMoneyBox_Records(obj);
context.SaveChanges();
return obj.Id;
}
public override Record GetRecordById(int id)
{
var context = new MoneyBoxEntities();
var obj = context.tblMoneyBox_Records.Where(item => item.Id == id).FirstOrDefault();
return Convert(obj);
}
public override Category GetCategoryById(int id)
{
var context = new MoneyBoxEntities();
var obj = context.tblMoneyBox_Categories.Where(item => item.Id == id).FirstOrDefault();
return Convert(obj);
}
public override void UpdateRecord(Record record)
{
var context = new MoneyBoxEntities();
var obj = new tblMoneyBox_Records {Id = record.Id};
context.AttachTo("tblMoneyBox_Records", obj);
record.CopyToObject(obj);
context.SaveChanges();
}
