public void deleteChi(int Ma)
{
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
var data = db.ChiRas.Find(Ma);
db.ChiRas.Remove(data);
db.SaveChanges();
db.Dispose();
}
public void DangKy(string tk, string matKhau)
{
TaiKhoan temp = new TaiKhoan();
temp.taiKhoan1 = tk;
temp.matKhau = matKhau;
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
db.TaiKhoans.Add(temp);
db.SaveChanges();
db.Dispose();
}
public void SetThuvao(string taikhoan, string tenthu, double gia, DateTime time)
{
ThuVao temp = new ThuVao();
temp.TenTK = taikhoan;
temp.TenThuVao = tenthu;
temp.GiaTien = gia;
temp.Time = time;
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
db.ThuVaos.Add(temp);
db.SaveChanges();
db.Dispose();
}
public void SetChiRa(string taikhoan, string tenchi, float gia, int soluong, DateTime time)
{
ChiRa temp = new ChiRa();
temp.TenTK = taikhoan;
temp.TenChi = tenchi;
temp.soluong = soluong;
temp.GiaTien = gia;
temp.Time = time;
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
db.ChiRas.Add(temp);
db.SaveChanges();
db.Dispose();
}
public bool IsValidLogin(string taiKhoan, string matKhau)
{
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
List <TaiKhoan> listTK = db.TaiKhoans.ToList();
TaiKhoan temp = new TaiKhoan();
temp.taiKhoan1 = taiKhoan;
temp.matKhau = matKhau;
bool isValid = false;
for (int i = 0; i < listTK.Count; i++)
{
if (listTK[i].taiKhoan1 == temp.taiKhoan1 &&
listTK[i].matKhau == temp.matKhau)
{
isValid = true;
}
}
return(isValid);
}
public double GetTongTienThu()
{
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
return(db.ThuVaos.Select(item => item.GiaTien).Sum());
}
public ThuVao[] GetThuVao()
{
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
return(db.ThuVaos.ToArray());
}
public ChiRa[] GetChiRa()
{
DataManagerMoneyEntities db = new DataManagerMoneyEntities();
return(db.ChiRas.ToArray());
}
