public ActionResult Create(HocVien hocVien, HttpPostedFileBase hinhAnh) { try { if (ModelState.IsValid) { string path = ""; if (hinhAnh != null && hinhAnh.ContentLength > 0) { string extension = Path.GetExtension(hinhAnh.FileName); if (extension.Equals(".jpg") || extension.Equals(".png") || extension.Equals(".jpeg")) { path = Path.Combine(Server.MapPath("~/Img/HocVien/"), hinhAnh.FileName); hinhAnh.SaveAs(path); } hocVien.HinhAnh = hinhAnh.FileName; var _daoHocVien = new HocVienDao(); hocVien.NgayDangKy = DateTime.Now; int _maGiaoVien = _daoHocVien.Insert(hocVien); if (_maGiaoVien > 0) { if (hocVien.Email == null) { return(RedirectToAction("Index", "HocVien")); } else { string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Email/HocVien.html")); content = content.Replace("{{TenHV}}", hocVien.TenHocVien.ToString()); content = content.Replace("{{NgaySinh}}", hocVien.NgaySinh.ToString()); content = content.Replace("{{SDT}}", hocVien.SDT.ToString()); content = content.Replace("{{DiaChi}}", hocVien.DiaChi.ToString()); content = content.Replace("{{NgayDangKy}}", hocVien.NgayDangKy.ToString()); new MailHelper().SendMail(hocVien.Email, "Chào mừng em đã tham gia vào đại gia đình Đan Thanh!", content); //SetAlert("") return(RedirectToAction("Index", "HocVien")); } } else { ModelState.AddModelError("", "Có lỗi khi thêm học viên"); } } } return(RedirectToAction("Index")); } catch { return(View()); } }
private void button1_Click_1(object sender, EventArgs e) { try { float n = float.Parse(textBox4.Text); if (!(0 <= n && n <= 10)) { textBox4.Text = ""; } } catch (Exception) { MessageBox.Show("Vui lòng nhập lại"); } try { float m = float.Parse(textBox5.Text); if (!(0 <= m && m <= 10)) { textBox5.Text = ""; } } catch (Exception) { MessageBox.Show("Vui lòng nhập lại"); } HocVien hv = new HocVien(); hv.MSSV = textBox1.Text; hv.Hoten = textBox2.Text; hv.SDT = int.Parse(textBox3.Text); hv.DiemToan = float.Parse(textBox4.Text.Trim()); hv.DiemVan = float.Parse(textBox5.Text); float dtb = float.Parse(textBox4.Text) + float.Parse(textBox5.Text) / 2; hv.DTB = dtb; try { FileStream fs = new FileStream("D:\\test.txt", FileMode.Append); BinaryFormatter bf = new BinaryFormatter(); bf.Serialize(fs, hv); fs.Close(); textBox1.ResetText(); textBox2.ResetText(); textBox3.ResetText(); textBox4.ResetText(); textBox5.ResetText(); MessageBox.Show("Thành công"); } catch { MessageBox.Show("Thêm thất bại"); } }
private void TraCuuHocVien_Load(object sender, EventArgs e) { HocVien hv = new HocVien(); DataTable tb = new DataTable(); tb = hv.getAll(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword()); cbxMaHV.DataSource = tb; cbxMaHV.ValueMember = tb.Columns[0].ToString(); cbxMaHV.DisplayMember = tb.Columns[0].ToString(); }
public JsonResult AddNew(AddNewHS_LOPModel data) { using (ELearningDB db = new ELearningDB()) { HocVien hv = db.HocViens.Find(data.ID); LopKiemTra l = db.LopKiemTras.Find(data.MaLop); l.HocViens.Add(hv); db.SaveChanges(); return(Json(new { success = true })); } }
public FrLyLich() { InitializeComponent(); cb_Lop.DataSource = new LopDAO().GetAll(); cb_Lop.DisplayMember = "Ten"; cb_Lop.ValueMember = "ID"; this.Text = "Thêm học viên"; btn_Luu.Text = "Thêm học viên"; lbMaHV.Text = ""; hv = new HocVien(); }
/// <summary> /// Nạp danh sách chưa có lớp lên giao diện /// </summary> public void LoadDSHVChuaCoLop() { gridDSHV.Rows.Clear(); dsChuaCoLop = HocVien.DanhSachChuaCoLop(); foreach (var i in dsChuaCoLop) { string[] s = { i.MaHV, i.HOCVIEN.TenHV, i.MaPhieu, i.KHOAHOC.TenKH }; gridDSHV.Rows.Add(s); } }
public bool Update(HocVien obj) { using (IDbConnection db = new SqlConnection(Helper.ConnectionString)) { if (db.State == ConnectionState.Closed) { db.Open(); } int result = db.Execute("sp_HocVien_Update", new { MaHV = obj.MaHV, TenHV = obj.TenHV, HoHV = obj.HoHV, NgaySinh = obj.NgaySinh, SoCMND = obj.SoCMND, NgayCapCMND = obj.NgayCapCMND, SDT = obj.SDT, DiaChi = obj.DiaChi, DiemTH = obj.DiemTH }, commandType: CommandType.StoredProcedure); return(result != 0); } }
private void frmThayDoiThongTinHV_Load(object sender, EventArgs e) { hv = HocVien.Select(GlobalSettings.UserID); txtMaHV.Text = hv.MaHV; txtTenHV.Text = hv.TenHV; dateNgaySinh.Value = (DateTime)hv.NgaySinh; cboGioiTinh.Text = hv.GioiTinhHV; txtDiaChi.Text = hv.DiaChi; txtSDT.Text = hv.SdtHV; txtEmail.Text = hv.EmailHV; }
private void button5_Click(object sender, EventArgs e) { FileStream fs = new FileStream("D:\\test.txt", FileMode.Open); BinaryFormatter bF = new BinaryFormatter(); HocVien hv = new HocVien(); while (fs.Position < fs.Length) { hv = (HocVien)bF.Deserialize(fs); richTextBox1.Text += hv.MSSV + "\n" + hv.Hoten + "\n" + hv.SDT + "\n" + hv.DiemToan + "\n" + hv.DiemVan + "\n" + hv.DTB + "\n\n"; } }
public static HocVien Save(HocVien obj, EntityState state) { if (state == EntityState.Added) { obj.MaHV = _container.Resolve <IHocVienRepository>().Insert(obj); } else { _container.Resolve <IHocVienRepository>().Update(obj); } return(obj); }
public List <HocVien> getListHocVien() { DataTable data = HocVienDAO.Instance.getListHocVien(); List <HocVien> list = new List <HocVien>(); foreach (DataRow item in data.Rows) { HocVien hocVien = new HocVien(item); list.Add(hocVien); } return(list); }
public ActionResult Edit(HocVien hv) { using (ELearningDB db = new ELearningDB()) { HocVien hocvien = db.HocViens.Find(hv.ID); hocvien.HoVaTen = hv.HoVaTen; hocvien.Email = hv.Email; hocvien.NgaySinh = hv.NgaySinh; db.SaveChanges(); return(RedirectToAction("Index")); } }
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { int maHV = (int)gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaHV"); HocVien hocVien = HocVienBUS.Instance.getHocVien(maHV); edtMaHV.Text = hocVien.MaHV.ToString(); edtHoTen.Text = hocVien.HoTen; dateEdtNgaySinh.DateTime = hocVien.NgaySinh; edtDiaChi.Text = hocVien.DiaChi; edtSoDT.Text = hocVien.SoDienThoai; edtGioiTinh.Text = hocVien.GioiTinh; }
public bool Insert(HocVien item) { try { db.HocViens.Add(item); db.SaveChanges(); //Them mon hoc List <Lop_MonHoc> monhoc = db.Lop_MonHoc.Where(x => x.LopID == item.LopID).ToList(); HocVien_MonHoc temp_mh = new HocVien_MonHoc(); temp_mh.HocVienID = item.ID; temp_mh.Diem = 0; foreach (Lop_MonHoc mh in monhoc) { temp_mh.MonHocID = mh.MonHocID; new HocVienDAO().Add_HocVien_MonHoc(temp_mh); } // Them mon the luc List <MonTheLuc> montheluc = db.MonTheLucs.ToList(); HocVien_TheLuc temp_mtl = new HocVien_TheLuc(); temp_mtl.HocVienID = item.ID; temp_mtl.KetQua = 0; foreach (var mtl in montheluc) { temp_mtl.MonTheLucID = mtl.ID; new HocVienDAO().Add_HocVien_MonTheLuc(temp_mtl); } //Them mon cong tac dang List <CongTacDang> monctd = db.CongTacDangs.ToList(); HocVien_CongTacDang temp_mctd = new HocVien_CongTacDang(); temp_mctd.HocVienID = item.ID; temp_mctd.Diem = 0; foreach (var mctd in monctd) { temp_mctd.CongTacDangID = mctd.ID; new HocVienDAO().Add_HocVien_CongTacDang(temp_mctd); } db.SaveChanges(); return(true); } catch (Exception e) { var x = e.ToString(); MessageBox.Show(x); return(false); } }
public bool xoaHocVien(int maHV) { HocVien hocVien = new HocVien() { MaHV = maHV }; using (var db = new TTTA_DBEntities()) { db.Entry(hocVien).State = System.Data.Entity.EntityState.Deleted; return(db.SaveChanges() > 0); } }
public void XoaListHV(List <string> mahv) { QLTTDayThem db = new QLTTDayThem(); for (int i = 0; i < mahv.Count; i++) { HocVien hv = db.HocViens.Find(mahv[i]); LopHoc lh = db.LopHocs.Find(hv.MaLH); lh.SiSo = lh.GetSiSo() - 1; db.HocViens.Remove(hv); db.SaveChanges(); } }
public List <HocVien> GetList() { List <HocVien> list = new List <HocVien>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.HocVien"); foreach (DataRow item in data.Rows) { HocVien obj = new HocVien(item); list.Add(obj); } return(list); }
public ActionResult CreateDetails(HoaDonDetails hoaDonDetails) { var hoaDonDao = new HoaDonDao(); var ctHDDao = new CT_HoaDonDao(); var lopHocDao = new LopHocDao(); var hocVienDao = new HocVienDao(); var hocVien = new HocVien(); var ctHD = new CT_HoaDon(); var lopHoc = new LopHoc(); var hoaDon = new HoaDon(); return(RedirectToAction("Index")); }
public IActionResult DocFileText() { var content = System.IO.File.ReadAllLines("HocVien.txt"); var hocvien = new HocVien { MaSo = int.Parse(content[0]), TenHocVien = content[1], SoDienThoai = content[2], DiemTrungBinh = double.Parse(content[3]), GioiTinh = content[4] == "true"? true : false }; return(View("ThongTin", hocvien)); }
public JsonResult Add_Edit(string id, string hoten, string ngaysinh, string sdt, string email, string diachi, string idtaikhoan) { var hv = new HocVien(); if (id != null) { var rId = int.Parse(id); hv = db.HocViens.Single(z => z.ID == rId); } hv.HoTen = hoten; hv.NgaySinh = ngaysinh.Replace('-', '/'); hv.SDT = sdt; hv.Email = email; hv.DiaChi = diachi; if (id == null)// Just Add Info { var idTK = int.Parse(idtaikhoan); var lhv = db.TaiKhoans.Where(z => z.IDChucVu == 3); var taikhoan = lhv.SingleOrDefault(z => z.ID == idTK); if (taikhoan == null) // Not Create TK { return(Json(new { data = false })); } if (taikhoan != null) { var hocvien = db.HocViens.SingleOrDefault(z => z.IDTaiKhoan == taikhoan.ID); if (hocvien != null) { // Already have infomation connect to this account return(Json(new { data = false })); } else { hv.IDTaiKhoan = idTK; // Have account but not have infomation } } } try { if (id == null) { db.HocViens.Add(hv); } db.SaveChanges(); return(Json(new { data = true })); } catch { return(Json(new { data = false })); } }
public IActionResult DemoJson() { var hocvien = new HocVien { MaSo = 1, HoTen = "loc", GioiTinh = true, SoDT = "012145646", DiemTb = 8.1, }; //return Json(hocvien); return(Json(new { status = true, TrungTam = "Nhất Nghệ", NgayTHanhLap = new DateTime(2013, 3, 10) })); }
public IActionResult DocFileText() { var content = System.IO.File.ReadAllLines("HocVien.txt"); var hocvien = new HocVien { MaSo = int.Parse(content[0]), TenHocVien = content[1], SDT = int.Parse(content[2]), DiemTB = double.Parse(content[3]), Gioitinh = content[4] == "true" ? true : false }; return(View("Index", hocvien)); }
public IActionResult Post([FromBody] HocVien hocVien) { if (ModelState.IsValid) { var hv = Find(hocVien.MaHV); if (hv == null) { dsHocVien.Add(hocVien); return(Ok()); } return(BadRequest()); } return(BadRequest()); }
public string Insert(HocVien obj) { using (IDbConnection db = new SqlConnection(Helper.ConnectionString)) { if (db.State == ConnectionState.Closed) { db.Open(); } DynamicParameters p = new DynamicParameters(); //p.Add("@MaHV", dbType: DbType.String, direction:ParameterDirection.Output,size:20); p.AddDynamicParams(new { MaHV = "", TenHV = obj.TenHV, HoHV = obj.HoHV, NgaySinh = obj.NgaySinh, SoCMND = obj.SoCMND, NgayCapCMND = obj.NgayCapCMND, SDT = obj.SDT, DiaChi = obj.DiaChi, DiemTH = obj.DiemTH, NgayDK = "", KyThi = "" }); db.Execute("sp_HocVien_Insert", p, commandType: CommandType.StoredProcedure); return(p.Get <string>("@MaHV")); } }
public ActionResult FirstLogin(int ID) { using (ELearningDB db = new ELearningDB()) { HocVien hv = db.HocViens.Find(ID); if (hv.HoVaTen != null) { Session.Abandon(); return(RedirectToAction("Index", "Login")); } HocVienModel hocvien = new HocVienModel(); hocvien.ID = hv.ID; return(View(hocvien)); } }
/// <summary> /// Nạp danh sách học viên /// </summary> public void InitializeHocVien() { gridDSHV.AutoGenerateColumns = false; Thread th = new Thread(() => { object dshv = HocVien.SelectAll(); gridDSHV.Invoke((MethodInvoker) delegate { gridDSHV.DataSource = dshv; }); }); th.Start(); }
private void btnSua_Click(object sender, EventArgs e) { try { if ((txtTenHocVien.Text == "") || (txtSDT.Text == "") || (txtDiaChi.Text == "") || (cbGioiTinh.Text == "") || (cbNgayRanh.Text == "") || (cbCaRanh.Text == "") || (cbTrinhDoHienTai.Text == "") || (cbTrinhDoMuonHoc.Text == "")) { MessageBox.Show("Bạn còn số liệu chưa nhập "); return; } string _maHV = dgvDSHVTiemNang.CurrentRow.Cells[0].Value.ToString();//cbbMaHocVien.Text; //Them hoc vien _objHV = new HocVien( _maHV, txtTenHocVien.Text, //hoten cbGioiTinh.Text, //gioitinh txtDiaChi.Text, //diachi txtSDT.Text, //sdt null, Double.Parse("0")); //Them thong tin dang ky cua hoc vien _objThongTinDangKy = new ThongTinDangKy( _maHV, dtNgayLapTTHV.Text, "Chưa học", Int32.Parse("0"), _objNgayHocBUS.GetMa_TheoTen(cbNgayRanh.Text), //mangayranh _objCaHocBUS.GetMa_TheoTen(cbCaRanh.Text), //macaranh _objTrinhDoBUS.GetMa_TheoTen(cbTrinhDoHienTai.Text), //matrinhdohientai _objTrinhDoBUS.GetMa_TheoTen(cbTrinhDoMuonHoc.Text), //matrinhdomuonhoc _objTrinhDoBUS.GetMa_TheoTen(cbTrinhDoMuonHoc.Text), //matrinhdoduochoc null); if (_objHVBUS.EditHocVien(_objHV) && _objThongTinDangKyBUS.EditThongTinDangKy(_objThongTinDangKy)) { LoadData(); MessageBox.Show("Sửa Thành Công ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); resettextbox(); } else { MessageBox.Show("Sửa Thất Bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { MessageBox.Show("Bạn đã nhập sai thông tin, vui lòng nhập lại !", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnHienTatCa_Click(object sender, EventArgs e) { gridDSHV.AutoGenerateColumns = false; thHocVien = new Thread(() => { //thPhieuGhiDanh.Join(); object source = HocVien.SelectAll(); gridDSHV.Invoke((MethodInvoker) delegate { gridDSHV.DataSource = source; }); }); thHocVien.Start(); }
public IActionResult DemoJson() { var HV = new HocVien { MaSo = 123123, TenHocVien = "Nguyen Van A", GioiTinh = true , SoDienThoai = "0909090900", DiemTrungBinh = 12 }; var data = new { HocVien = HV, TrungTam = "Nhat Nghe", NgayThanhLap = new DateTime(1234, 12, 12) }; return(Json(data)); }
private void btnXoa_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Bạn có muốn xóa?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { HocVien.Delete(gridDSHV.SelectedRows[0].Cells["clmMaHV"].Value.ToString()); MessageBox.Show("Xóa học viên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); btnXemTatCa_Click(sender, e); } } catch { MessageBox.Show("Có lỗi xảy ra", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }