public void DeleteExpense(int id)
{
var db = new ExpenseManagementEntities();
var tn = db.THUNHAP.Find(id);
db.THUNHAP.Remove(tn);
db.SaveChanges();
}
public void DeletePay(int id)
{
var db = new ExpenseManagementEntities();
var ct = db.CHITIEU.Find(id);
db.CHITIEU.Remove(ct);
db.SaveChanges();
}
public void UpdatePay(int id, string danhmuc, int tien, DateTime ngay, string ghichu)
{
var db = new ExpenseManagementEntities();
var ct = db.CHITIEU.Find(id);
ct.DANHMUC = danhmuc;
ct.TIEN_1 = tien;
ct.NGAY = ngay;
ct.GHICHU = ghichu;
db.Entry(ct).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public void UpdateExpense(int id, string danhmuc, int tien, DateTime ngay, string ghichu)
{
var db = new ExpenseManagementEntities();
var tn = db.THUNHAP.Find(id);
tn.DANHMUC = danhmuc;
tn.TIEN = tien;
tn.NGAY = ngay;
tn.GHICHU = ghichu;
db.Entry(tn).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public void CreatePay(string danhmuc, int tien, DateTime ngay, string ghichu)
{
var ct = new CHITIEU();
ct.DANHMUC = danhmuc;
ct.TIEN_1 = tien;
ct.NGAY = ngay;
ct.GHICHU = ghichu;
var db = new ExpenseManagementEntities();
db.CHITIEU.Add(ct);
db.SaveChanges();
}
public void CreateExpense(string danhmuc, int tien, DateTime ngay, string ghichu)
{
var tn = new THUNHAP();
tn.DANHMUC = danhmuc;
tn.TIEN = tien;
tn.NGAY = ngay;
tn.GHICHU = ghichu;
var db = new ExpenseManagementEntities();
db.THUNHAP.Add(tn);
db.SaveChanges();
}
public CHITIEU GetPay(int id)
{
var db = new ExpenseManagementEntities();
return(db.CHITIEU.Find(id));
}
public CHITIEU[] GetPays()
{
var db = new ExpenseManagementEntities();
return(db.CHITIEU.ToArray());
}
public THUNHAP GetExpenses(int id)
{
var db = new ExpenseManagementEntities();
return(db.THUNHAP.Find(id));
}
public THUNHAP[] GetExpenses()
{
var db = new ExpenseManagementEntities();
return(db.THUNHAP.ToArray());
}
