public DataTable GetBienLai(string mahv, int hp) { DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("TenLop", typeof(string)), new DataColumn("HoTen", typeof(string)), new DataColumn("HocPhi", typeof(int)), }); QLTTDayThem db = new QLTTDayThem(); BienLai bl = db.BienLais.Find(mahv); bl.HocPhi = hp; db.SaveChanges(); // get dữ liệu vào datatable DataRow dr = dt.NewRow(); dr["TenLop"] = bl.LopHoc.TenLop; dr["HoTen"] = bl.HocVien.HoTen; dr["HocPhi"] = Convert.ToInt32(bl.HocPhi); dt.Rows.Add(dr); return(dt); }
public void AddBienLai(BienLai bl) { QLTTDayThem db = new QLTTDayThem(); db.BienLais.Add(bl); db.SaveChanges(); }
public void ChangeState(string mahv) { QLTTDayThem db = new QLTTDayThem(); BienLai bl = db.BienLais.Find(mahv); bl.TinhTrang = "Đã nộp"; db.SaveChanges(); }
public void addKhachHang(BienLai b) { provider.Connect(); string bd = b.GioBd.ToString("yyyy-MM-dd HH:mm:ss"); string kt = b.GioKt.ToString("yyyy-MM-dd HH:mm:ss"); string sql = "insert into BIENLAI(MANHANVIEN, MABAN, MAKH, THOIGIAN, TONGTIEN, GIOBD, GIOKT) VALUES ('" + b.Nhanvien.Manv + "'," + b.Ban.Maban1 + "," + b.Kh.Makh + ",'" + b.Thoigian + "','" + b.TongTien1 + "','" + bd + "','" + kt + "')"; provider.executeNonQuery(sql); }
public frmChiTietBienLai(BienLai bienlai) : this() { _BienLai = new BienLai(); _BienLai.HoTen = bienlai.HoTen; _BienLai.GioiTinh = bienlai.GioiTinh; _BienLai.MaSV = bienlai.MaSV; _BienLai.NgaySinh = bienlai.NgaySinh; _BienLai.lstMonHoc = bienlai.lstMonHoc; dataGridSinhVien.DataSource = _BienLai.lstMonHoc; InitDatainControl(); }
public ActionResult SuaBienLai(BienLai BienLai, FormCollection form) { ViewBag.HeHoc_MHH = new SelectList(db.HeHocs.ToList().OrderBy(n => n.MaHeHoc), "MaHeHoc", "MaHeHoc"); ViewBag.Ma_HS = new SelectList(db.HocSinhs.ToList().OrderBy(n => n.MaHocSinh), "MaHocSinh", "MaHocSinh"); BienLai.TienAn1ngay = Convert.ToInt32(form["txt_NewTienAn1ngay"]); BienLai.NgayNop = Convert.ToDateTime(form["txt_NewNgayNop"]); BienLai.TienAn1thang = Convert.ToDouble(BienLai.TienAn1ngay * 26); BienLai.NguoiNop = form["txt_NewNguoiNop"]; BienLai.TrangThai = Convert.ToBoolean(form["txtTrangThai"]); db.Entry(BienLai).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("BienLai")); }
private void btnPay_Click(object sender, EventArgs e) { int makh = comKH.SelectedValue.GetHashCode(); KhachHang kh = new KhachHangBUS().GetKhachHangbyID(makh); String thoigian = txtGio.Text; String gia = txtGia.Text; BienLai a = new BienLai(nhanvien, ban, kh, ban.GioBd, ban.GioKt, thoigian, gia); new BienLaiBUS().addBienLai(a); frmBienLai bl = new frmBienLai(a); bl.Show(); this.Close(); }
public void ExecuteDB(HocVien h) { QLTTDayThem db = new QLTTDayThem(); HocVien hv = db.HocViens.Find(h.MaHV); if (hv != null) { string malh = hv.MaLH; // set lại dữ liệu hv.HoTen = h.HoTen; hv.MaLH = h.MaLH; hv.NamSinh = h.NamSinh; hv.GioiTinh = h.GioiTinh; hv.DiaChi = h.DiaChi; hv.SDT = h.SDT; hv.TinhTrang = h.TinhTrang; db.SaveChanges(); // set lại sĩ số if (malh != h.MaLH) { LopHoc lh1 = db.LopHocs.Find(h.MaLH); lh1.SiSo = lh1.GetSiSo(); LopHoc lh2 = db.LopHocs.Find(malh); lh2.SiSo = lh2.GetSiSo(); db.SaveChanges(); } } else { db.HocViens.Add(h); LopHoc lh = db.LopHocs.Find(h.MaLH); lh.SiSo = lh.GetSiSo(); db.SaveChanges(); // add biên lai BienLai bl = new BienLai() { MaHV = h.MaHV, MaLH = h.MaLH, TinhTrang = "Chưa nộp", HocPhi = 0 }; BLL_BienLai.Instance.AddBienLai(bl); } }
public ActionResult ThemBienLai(BienLai BienLai, FormCollection form) { ViewBag.HeHoc_MHH = new SelectList(db.HeHocs.ToList().OrderBy(n => n.MaHeHoc), "MaHeHoc", "MaHeHoc"); ViewBag.Ma_HS = new SelectList(db.HocSinhs.ToList().OrderBy(n => n.MaHocSinh), "MaHocSinh", "MaHocSinh"); BienLai.MaHocSinh = form["txt_NewMaHocSinh"].ToString(); BienLai.TienAn1ngay = Convert.ToInt32(form["txt_NewTienAn1ngay"]); BienLai.NgayNop = Convert.ToDateTime(form["txt_NewNgayNop"]); BienLai.TienAn1thang = Convert.ToDouble(BienLai.TienAn1ngay * 26); BienLai.NguoiNop = form["txt_NewNguoiNop"]; BienLai.TrangThai = Convert.ToBoolean(form["txtTrangThai"]); // BienLai.TongCong = Convert.ToDouble(form["tong"]); //BienLai.TongCong = db.BienLais.Add(BienLai); db.SaveChanges(); return(RedirectToAction("BienLai")); }
private void btnInBienLai_Click(object sender, EventArgs e) { if (txtMaSV.Text != "") { BienLai bienlai = new BienLai(); bienlai.MaSV = txtMaSV.Text; bienlai.HoTen = txtTenSV.Text; bienlai.GioiTinh = txtGioiTinh.Text; bienlai.NgaySinh = dtpkNgaySinh.Value.ToString(); List <MonHoc> lstMH = new List <MonHoc>(); for (int i = 0; i < dataGridChiTiet.Rows.Count - 1; i++) { string maMH = dataGridChiTiet.Rows[i].Cells[0].Value.ToString(); string tenMH = dataGridChiTiet.Rows[i].Cells[1].Value.ToString(); string soTC = dataGridChiTiet.Rows[i].Cells[2].Value.ToString(); string maMucHP = dataGridChiTiet.Rows[i].Cells[3].Value.ToString(); string soTien = dataGridChiTiet.Rows[i].Cells[4].Value.ToString(); bool dangKy = bool.Parse(dataGridChiTiet.Rows[i].Cells[5].Value.ToString()); MonHoc monhoc = new MonHoc(); monhoc.MaMonHoc = maMH; monhoc.TenMonHoc = tenMH; monhoc.soTinChi = int.Parse(soTC); monhoc.MaMucHP = maMucHP; monhoc.soTien = double.Parse(soTien); monhoc.dangky = dangKy; if (dangKy == true) { lstMH.Add(monhoc); } } bienlai.lstMonHoc = lstMH; frmChiTietBienLai frmCT = new frmChiTietBienLai(bienlai); frmCT.ShowDialog(); } else { MessageBox.Show("Ban chua chon sinh vien!", "Thong bao"); } }
public frmBienLai(BienLai bl) { this.bienlai = bl; InitializeComponent(); }
public void addBienLai(BienLai a) { new BienLaiDAO().addKhachHang(a); }
public ActionResult SuaBienLai(int mabienlai) { BienLai BienLai = db.BienLais.SingleOrDefault(n => n.MaBienLai == mabienlai); return(View(BienLai)); }