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