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