public void SetMoctien(double moctien, string taikhoan) { DataManagerMoneyEntities db = new DataManagerMoneyEntities(); db.TaiKhoans.Find(taikhoan).Moctien = moctien; db.SaveChanges(); }
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 Editthu(int ma, string tenthu, float gia, DateTime time) { var db = new DataManagerMoneyEntities(); var t = db.ThuVaos.Find(ma); t.TenThuVao = tenthu; t.GiaTien = gia; t.Time = time; db.SaveChanges(); }
public void EditChi(int ma, string tenchi, double gia, int soluong, DateTime time) { var db = new DataManagerMoneyEntities(); var t = db.ChiRas.Find(ma); t.TenChi = tenchi; t.GiaTien = gia * soluong; t.Time = time; t.soluong = soluong; db.SaveChanges(); }
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 double GetTongTienThu() { DataManagerMoneyEntities db = new DataManagerMoneyEntities(); var temp = db.ThuVaos.Select(item => item.GiaTien); if (temp == null || temp.Count() == 0) { return(0); } else { return(temp.Sum()); } }
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 * soluong; 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 GetMocTien(string taikhoan) { DataManagerMoneyEntities db = new DataManagerMoneyEntities(); return(db.TaiKhoans.Find(taikhoan).Moctien.Value); }
public ThuVao[] GetThuVao() { DataManagerMoneyEntities db = new DataManagerMoneyEntities(); return(db.ThuVaos.ToArray()); }
public ChiRa[] GetChiRa() { DataManagerMoneyEntities db = new DataManagerMoneyEntities(); return(db.ChiRas.ToArray()); }