public static bool UpdateMaDangNhap7So()
{
try
{
List <TAIKHOAN> _lstTaiKhoan = (from p in GlobalSettings.Database.TAIKHOANs
where p.LoaiTaiKhoanId == 2
select p).ToList();
foreach (var item in _lstTaiKhoan)
{
HOCVIEN _hocvien = (from p in GlobalSettings.Database.HOCVIENs
where p.TaiKhoanId == item.TaiKhoanId
select p).Single();
TAIKHOAN _taikhoan = SelectSingle(item.TaiKhoanId);
_taikhoan.TenDangNhap = string.Format("{0}{1:D7}", "HV", _hocvien.HocVienId);
Database.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult DatHang()
{
//Kiểm tra session giỏ hàng tồn tại chưa
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
//Thêm chi tiết đơn đặt hàng
List <ItemGioHang> listGH = getGioHang();
HOCVIEN hocvien = (HOCVIEN)Session["TaiKhoan"];
CHITIETDANGKY ctdk;
foreach (var item in listGH)
{
ctdk = new CHITIETDANGKY();
ctdk.MA_HV = hocvien.MA_HV;
ctdk.NGAY_DK = DateTime.Now;
ctdk.XACNHAN = false;
ctdk.MA_LH = item.Ma_Lop_Hoc;
ctdk.SO_LUONG = item.SL;
ctdk.TONG_TIEN = item.Tong_Tien;
db.CHITIETDANGKY.Add(ctdk);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XemGioHang"));
}
/// <summary>
/// Nạp học viên lên giao diện
/// </summary>
/// <param name="hv"></param>
public void LoadUI(HOCVIEN hv)
{
if (hv == null)
{
txtMaHV.Text = HocVien.AutoGenerateId();
cboGioiTinh.SelectedIndex = 0;
}
else
{
txtMaHV.Text = hv.MaHV;
txtHoTen.Text = hv.TenHV;
dateNgaySinh.Value = (DateTime)hv.NgaySinh;
cboGioiTinh.Text = hv.GioiTinhHV;
txtDiaChi.Text = hv.DiaChi;
txtSDT.Text = hv.SdtHV;
txtEmail.Text = hv.EmailHV;
cboLoaiHV.SelectedValue = hv.MaLoaiHV;
if (hv.MaLoaiHV == "LHV01")
{
cboLoaiHV.Enabled = false;
txtMatKhau.Enabled = false;
}
if (hv.TenDangNhap != null)
{
txtTenDangNhap.Text = hv.TenDangNhap;
txtMatKhau.Text = hv.TAIKHOAN.MatKhau;
}
else
{
txtTenDangNhap.Text = txtMatKhau.Text = string.Empty;
}
}
}
public ActionResult DangNhap(FormCollection f)
{
string ten = f["TEN_HV"].ToString();
string password = f["MATKHAUHV"].ToString();
// Chọn ra học viên có tên và mật khẩu trùng khi nhập form Dang Nhap
HOCVIEN hocvien = db.HOCVIEN.SingleOrDefault(n => n.TEN_HV == ten && n.MATKHAUHV == password);
try
{
//nếu đăng nhập đúng mk và pass
if (hocvien != null)
{
//gán session Tài khoản
Session["TaiKhoan"] = hocvien as HOCVIEN;
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
throw;
}
ViewBag.ErrorDangNhap = 1;
//gán viewbag bằng text khi đăng nhập sai
ViewBag.ErrorText = "Tên đăng nhập hoặc mật khẩu sai!! Vui lòng kiểm tra lại.";
return(View("Index"));
}
public int update(string mahv, string hoten, int gioitinh, string diachi, string sdt, string email, DateTime ngaydk, int tinhtrang, DateTime ngaysinh)
{
try
{
using (QLTTEntities qltt = new QLTTEntities())
{
HOCVIEN hv = qltt.HOCVIENs.Where(p => p.MAHV == mahv).FirstOrDefault();
if (hv != null)
{
hv.HOTEN = hoten;
hv.GIOITINH = gioitinh;
hv.DIACHI = diachi;
hv.NGSINH = ngaysinh;
hv.SDT = sdt;
hv.EMAIL = email;
hv.NGAYDK = ngaydk;
hv.TINHTRANG = tinhtrang;
qltt.SaveChanges();
return(1);
}
return(0);
}
}
catch
{
return(0);
}
}
private bool vSaveStudents(int vCheck)
{
boHocVien = new BO_HOCVIEN();
hocvien = new HOCVIEN();
hocvien.HOV_Code = txtStudentCode.Text;
hocvien.HOV_FirstName = txtFirstName.Text.Trim();
hocvien.HOV_LastName = txtLastName.Text.Trim();
hocvien.HOV_FullName = txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim();
hocvien.HOV_BirthDay = txtBirthDay.Text;
hocvien.HOV_Address = txtAddress.Text;
hocvien.HOV_Phone = txtPhone.Text;
hocvien.HOV_GhiChu = memoRemarks.Text.Trim();
hocvien.HOV_QuocTich = txtQuocTich.Text.Trim();
hocvien.HOV_NoiSinh = lookUpBirthPlace.GetColumnValue("TIN_ID").ToString();
hocvien.HOV_DonVi = lookUpDonvi.GetColumnValue("DON_ID").ToString();
if (vCheck == 1)
{
gHocVienID = boHocVien.insert(hocvien);
flagSave = true;
}
else if (vCheck == 2)
{
//hocvien.HOV_ID = mIdStudents;
//boHocVien.update(hocvien);
////mIdStudents lấy lúc selectRow
//loadDataToGrid();
}
return(flagSave);
}
public ActionResult DoiMatKhau(FormDoiMatKhau form)
{
if (Session[SesHocVien] == null)
{
return RedirectToAction(actionName: "DangNhap");
}
ViewData["matkhaucu"] = "";
if (ModelState.IsValid)
{
HOCVIEN hv = db.HOCVIENs.SingleOrDefault(n => n.Matkhau == form.MatKhauCu);
if (hv == null)
{
ViewData["matkhaucu"] = "Mật khẩu cũ không đúng";
return View(form);
}
hv.Matkhau = form.MatKhauMoi;
db.SubmitChanges();
return RedirectToAction(actionName: "Index");
}
else
{
form.MatKhauMoi = "";
return View(form);
}
}
public ActionResult ThuGiang (int baigiang)
{
if(Session[SesHocVien] == null)
{
return RedirectToAction(actionName: "DangNhap");
}
HOCVIEN hocvien = (HOCVIEN)Session[SesHocVien];
BaiGiang giang;
var baiGiang = (from bg in db.BaiGiangs
join kh in db.KHOAHOCs on bg.MaKH equals kh.MaKH
join ct in db.CHITIETDONTHANGs on kh.MaKH equals ct.MaKH
join bl in db.DONDATHANGs on ct.MaDonHang equals bl.MaDonHang
where bg.MaBaiGiang == baigiang && hocvien.MaHV == bl.MaHV && bl.Dathanhtoan == true
select bg);
if(baiGiang.Count() == 1)
{
giang = baiGiang.FirstOrDefault();
} else
{
return View();
}
return View(giang);
}
public ActionResult SuaThongTin(HOCVIEN hv)
{
if (Session[SesHocVien] == null)
{
return RedirectToAction("DangNhap");
}
if (ModelState.IsValidField("HoTen") && ModelState.IsValidField("Email"))
{
HOCVIEN hocvien = (HOCVIEN)Session[SesHocVien];
HOCVIEN hocVien = db.HOCVIENs.SingleOrDefault(n => n.MaHV == hocvien.MaHV);
hocVien.HoTen = hv.HoTen;
if (hv.Ngaysinh != null)
{
hocVien.Ngaysinh = hv.Ngaysinh;
}
hocVien.DiachiHV = hv.DiachiHV;
hocVien.DienthoaiHV = hv.DienthoaiHV;
hocVien.Email = hv.Email;
db.SubmitChanges();
Session[SesHocVien] = hocVien;
return RedirectToAction(actionName: "Index");
}
else
{
return View(hv);
}
}
/// <summary>
/// Nạp học viên lên giao diện
/// </summary>
/// <param name="hv"></param>
public void LoadPanelControl(HOCVIEN hv = null)
{
try
{
if (hv == null)
{
ResetPanelControl();
txtMaHV.Text = HocVien.AutoGenerateId();
txtTenDangNhap.Text = txtMaHV.Text;
cboLoaiHV_SelectedValueChanged(null, null);
}
else
{
txtMaHV.Text = hv.MaHV;
txtHoTen.Text = hv.TenHV;
dateNgaySinh.Value = (DateTime)hv.NgaySinh;
cboGioiTinh.Text = hv.GioiTinhHV;
txtDiaChi.Text = hv.DiaChi;
txtSDT.Text = hv.SdtHV;
txtEmail.Text = hv.EmailHV;
cboLoaiHV.SelectedValue = hv.MaLoaiHV;
txtTenDangNhap.Text = hv.TenDangNhap;
txtMatKhau.Text = hv.TAIKHOAN != null ? hv.TAIKHOAN.MatKhau : string.Empty;
}
}
catch
{
ResetPanelControl();
LockPanelControl();
}
}
public void update(HOCVIEN hocvien)
{
SqlParameter[] prams =
{
MakeInParam("@HOV_ID", SqlDbType.Int, 4, hocvien.HOV_ID),
MakeInParam("@HOV_Code", SqlDbType.NVarChar, 50, hocvien.HOV_Code),
MakeInParam("@HOV_FirstName", SqlDbType.NVarChar, 50, hocvien.HOV_FirstName),
MakeInParam("@HOV_LastName", SqlDbType.NVarChar, 20, hocvien.HOV_LastName),
MakeInParam("@HOV_FullName", SqlDbType.NVarChar, 20, hocvien.HOV_FullName),
MakeInParam("@HOV_BirthDay", SqlDbType.NVarChar, 50, hocvien.HOV_BirthDay),
MakeInParam("@HOV_QuocTich", SqlDbType.NVarChar, 50, hocvien.HOV_QuocTich),
MakeInParam("@HOV_NoiSinh", SqlDbType.NVarChar, 50, hocvien.HOV_NoiSinh),
MakeInParam("@HOV_Phone", SqlDbType.NVarChar, 12, hocvien.HOV_Phone),
MakeInParam("@HOV_Address", SqlDbType.NVarChar, 200, hocvien.HOV_Address),
MakeInParam("@HOV_DonVi", SqlDbType.NVarChar, 100, hocvien.HOV_DonVi),
//MakeInParam("@HOV_ChucDanh",SqlDbType.NVarChar,50,hocvien.HOV_ChucDanh),
MakeInParam("@HOV_GhiChu", SqlDbType.NVarChar, 2000, hocvien.HOV_GhiChu)
};
int errorcode = RunProc("usp_UpdateHOCVIEN", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
public int insert(HOCVIEN hocvien)
{
SqlParameter[] prams =
{
MakeInParam("@HOV_Code", SqlDbType.NVarChar, 50, hocvien.HOV_Code),
MakeInParam("@HOV_FirstName", SqlDbType.NVarChar, 50, hocvien.HOV_FirstName),
MakeInParam("@HOV_LastName", SqlDbType.NVarChar, 20, hocvien.HOV_LastName),
MakeInParam("@HOV_FullName", SqlDbType.NVarChar, 20, hocvien.HOV_FullName),
MakeInParam("@HOV_BirthDay", SqlDbType.NVarChar, 50, hocvien.HOV_BirthDay),
MakeInParam("@HOV_QuocTich", SqlDbType.NVarChar, 50, hocvien.HOV_QuocTich),
MakeInParam("@HOV_NoiSinh", SqlDbType.NVarChar, 50, hocvien.HOV_NoiSinh),
MakeInParam("@HOV_Phone", SqlDbType.NVarChar, 12, hocvien.HOV_Phone),
MakeInParam("@HOV_Address", SqlDbType.NVarChar, 200, hocvien.HOV_Address),
MakeInParam("@HOV_DonVi", SqlDbType.NVarChar, 100, hocvien.HOV_DonVi),
//MakeInParam("@HOV_ChucDanh",SqlDbType.NVarChar,50,hocvien.HOV_ChucDanh),
MakeInParam("@HOV_GhiChu", SqlDbType.NVarChar, 2000, hocvien.HOV_GhiChu),
//MakeInParam("@HOV_ID",SqlDbType.Int ,4,hocvien.HOV_ID)
MakeOutParam("@HOV_ID", SqlDbType.Int, 4)
};
errorcode = RunProc("usp_InsertHOCVIEN", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
else
{
return(gId = (int)prams[11].Value);
}
}
protected void Page_Load(object sender, EventArgs e)
{
QLHocVien.GetAll();
listHOCVIEN = QLHocVien.listHOCVIEN;
hocVien = listHOCVIEN[1];
GetData();
int maKQ = LayMaKQ();
KETQUAHOC kqHoc = new KETQUAHOC(maKQ, 0, "", false, "Chưa học", true);
try
{
QLKetQuaHoc.Insert(kqHoc);
string time = DateTime.Now.ToString().Replace("/", "");
KETQUADANGKY kqdk = new KETQUADANGKY(maKQ, hocVien.MAHV, maCTKH, time, "", "Online", true);
QLKetQuaDangKy.Insert(kqdk);
}
catch (Exception)
{
Response.Redirect("\\404.html");
}
Response.Redirect("Index.aspx");
}
public int insert(string mahv, string hoten, int gioitinh, string diachi, string sdt, string email, DateTime ngaydk, int tinhtrang, DateTime ngaysinh)
{
//Console.Write(mahv+" "+ hoten+" "+gioitinh+" "+diachi+" "+sdt+" "+email+" "+ngaydk+" "+tinhtrang+" "+ngaysinh);
try
{
using (QLTTEntities qltt = new QLTTEntities())
{
HOCVIEN hv = new HOCVIEN()
{
MAHV = mahv,
HOTEN = hoten,
GIOITINH = gioitinh,
NGSINH = ngaysinh,
DIACHI = diachi,
SDT = sdt,
EMAIL = email,
NGAYDK = ngaydk,
TINHTRANG = tinhtrang
};
qltt.HOCVIENs.Add(hv);
qltt.SaveChanges();
}
return(1);
}
catch
{
return(0);
}
}
/// <summary>
/// Cập nhật một học viên
/// </summary>
/// <param name="hocVien">Học viên cần cập nhật</param>
/// <param name="taiKhoan">Tài khoản cần thêm mới</param>
public static void Update(HOCVIEN hocVien, TAIKHOAN taiKhoan = null)
{
var hocVienCu = Select(hocVien.MaHV);
//không thay đổi loại
hocVienCu.TenHV = hocVien.TenHV;
hocVienCu.NgaySinh = hocVien.NgaySinh;
hocVienCu.GioiTinhHV = hocVien.GioiTinhHV;
hocVienCu.DiaChi = hocVien.DiaChi;
hocVienCu.SdtHV = hocVien.SdtHV;
hocVienCu.EmailHV = hocVien.EmailHV;
hocVienCu.NgayTiepNhan = hocVien.NgayTiepNhan;
if (hocVienCu.MaLoaiHV != hocVien.MaLoaiHV)
{
//đổi từ tiềm năng sang chính thức
if (hocVien.MaLoaiHV == "LHV01")
{
Database.TAIKHOANs.InsertOnSubmit(taiKhoan);
hocVienCu.MaLoaiHV = hocVien.MaLoaiHV;
hocVienCu.TenDangNhap = hocVien.TenDangNhap;
}
else
{
hocVienCu.MaLoaiHV = hocVien.MaLoaiHV;
Database.TAIKHOANs.DeleteOnSubmit((from p in Database.TAIKHOANs where p.TenDangNhap == hocVienCu.TenDangNhap select p).Single());
hocVienCu.TenDangNhap = null;
}
}
Database.SubmitChanges();
}
private void btnThemVaoLop_Click(object sender, EventArgs e)
{
try
{
HOCVIEN hv = HocVien.Select(gridDSHV.SelectedRows[0].Cells["clmMaHV"].Value.ToString());
if (gridDSHVLop.Rows.Count < GlobalSettings.QuyDinh["QD0000"] ||
MessageBox.Show("Số học viên tối đa của lớp là " + GlobalSettings.QuyDinh["QD0000"] + Environment.NewLine + "Bạn có chắc sẽ thêm?",
"Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
string[] s = new string[]
{
hv.MaHV,
hv.TenHV,
((DateTime)hv.NgaySinh).ToString("dd/MM/yyyy"),
hv.GioiTinhHV,
hv.SdtHV,
hv.DiaChi,
gridDSHV.SelectedRows[0].Cells["clmMaPhieu"].Value.ToString()
};
gridDSHV.Rows.RemoveAt(gridDSHV.SelectedRows[0].Index);
gridDSHVLop.Rows.Add(s);
}
}
catch { }
}
public bool Update(HOCVIEN HOCVIEN)
{
if (baseFunctions.Update(HOCVIEN) > 0)
{
return(true);
}
return(false);
}
public void delete(int hocvien_ID)
{
DAL_HOCVIEN hocvien_dal = new DAL_HOCVIEN();
HOCVIEN hocvien = new HOCVIEN();
hocvien.HOV_ID = hocvien_ID;
hocvien_dal.delete(hocvien);
}
public bool Insert(HOCVIEN HOCVIEN)
{
if (baseFunctions.Add(HOCVIEN) > 0)
{
return(true);
}
return(false);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
HOCVIEN obj = new HOCVIEN();
obj.HOV_ID = int.Parse(dt.Rows[i]["HOV_ID"].ToString());
//some column
return((object)obj);
}
public ActionResult Index()
{
if (Session[SesHocVien] != null)
{
HOCVIEN hv = (HOCVIEN)Session[SesHocVien];
return View(hv);
}
return RedirectToAction(controllerName: "NguoiDung", actionName: "DangNhap");
}
/// <summary>
/// Thêm một học viên
/// </summary>
/// <param name="hocVien">Học viên cần thêm</param>
public static void Insert(HOCVIEN hocVien, TAIKHOAN taiKhoan)
{
if (hocVien.MaLoaiHV == "LHV01")
{
Database.TAIKHOANs.InsertOnSubmit(taiKhoan);
}
Database.HOCVIENs.InsertOnSubmit(hocVien);
Database.SubmitChanges();
}
public DataTable getCAP_CHUNGCHI_HV_SearchLastName(string lastName)
{
HOCVIEN searchLastName = new HOCVIEN();
searchLastName.HOV_LastName = lastName;
DAL_CAP_CHUNGCHI dao = new DAL_CAP_CHUNGCHI();
return(dao.getCAP_CHUNGCHI_HV_SearchLastName(searchLastName));
}
private void frmThemTuVanHocVien_Load(object sender, EventArgs e)
{
dateNgayTuVan.DateTime = DateTime.Now;
HOCVIEN _hocvien = HocVienLogic.SelectSingle(this.HocVienId_Select);
lblMaHocVien.Text = _hocvien.MaHocVien;
lblTenHocVien.Text = _hocvien.TenHocVien;
txtNguoiTuVan.Focus();
}
public void XoaHocVien(String mahv)
{
HOCVIEN hvs = qlhv.HOCVIENs.Where(d => d.MaHV == mahv).FirstOrDefault();
if (hvs != null)
{
qlhv.HOCVIENs.DeleteOnSubmit(hvs);
qlhv.SubmitChanges();
}
}
public ActionResult SuaThongTin()
{
if (Session[SesHocVien] == null)
{
return RedirectToAction("DangNhap");
}
HOCVIEN hv = (HOCVIEN)Session[SesHocVien];
return View(hv);
}
private void frmThayDoiThongTinHV_Load(object sender, EventArgs e)
{
hv = HocVienLogic.SelectSingle(GlobalSettings.UserID);
txtMaHV.Text = hv.MaHocVien;
txtTenHocVien.Text = hv.TenHocVien;
dateNgaySinh.Value = (DateTime)hv.NgaySinh;
cboGioiTinh.Text = hv.GioiTinh;
txtDiaChi.Text = hv.DiaChi;
txtSDT.Text = hv.Sdt;
txtEmail.Text = hv.Email;
}
public void delete(HOCVIEN hocvien)
{
SqlParameter[] prams =
{
MakeInParam("@HOV_ID", SqlDbType.Int, 4, hocvien.HOV_ID)
};
int errorcode = RunProc("usp_DeleteHOCVIEN", prams);
if (errorcode > 0)
{
throw new Exception("Error");
}
}
private void loadDataByID()
{
boHv = new BO_HOCVIEN();
hocvien = new HOCVIEN();
hocvien.HOV_ID = sId = int.Parse(vRow["HOV_ID"].ToString());
try
{
boHv.getHocVienByID(hocvien);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void ThemHocVien(String mahv, String tenhv, String gioitinh, DateTime ngaysinh, String dienthoai, String diachi, String malh)
{
HOCVIEN hv = new HOCVIEN();
hv.MaHV = mahv;
hv.TenHV = tenhv;
hv.GioiTinh = gioitinh;
hv.NgaySinh = ngaysinh;
hv.DienThoai = dienthoai;
hv.DiaChi = diachi;
hv.MaLH = malh;
qlhv.HOCVIENs.InsertOnSubmit(hv);
qlhv.SubmitChanges();
}
