public void Delete(Guid id)
{
var context = new HomeworkDBEntities();
var item = context.AccountBook.Where(obj => id == obj.Id).FirstOrDefault();
if (item != null)
{
context.AccountBook.Remove(item);
context.SaveChanges();
}
}
public void Create(HomeworkViewModel model)
{
var context = new HomeworkDBEntities();
var item = new ORM.AccountBook();
item.Id = Guid.NewGuid();
item.Amounttt = (int)model.Amount;
item.Categoryyy = model.Type;
item.Remarkkk = model.Name;
item.Dateee = model.CreateDate;
context.AccountBook.Add(item);
context.SaveChanges();
}
public void Update(HomeworkViewModel model)
{
var context = new HomeworkDBEntities();
var item = context.AccountBook.Where(obj => model.ID == obj.Id).FirstOrDefault();
if (item != null)
{
item.Amounttt = (int)model.Amount;
item.Categoryyy = model.Type;
item.Remarkkk = model.Name;
item.Dateee = model.CreateDate;
context.SaveChanges();
}
}
public List <HomeworkViewModel> GetList()
{
var context = new HomeworkDBEntities();
int i = 0;
var list =
(from item in context.AccountBook
select new HomeworkViewModel()
{
ID = item.Id,
Amount = item.Amounttt,
Name = item.Remarkkk,
Type = item.Categoryyy,
TypeName = (item.Categoryyy == 0) ? "收入" : "支出",
CreateDate = item.Dateee
}).ToList();
return(list);
}