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