public JsonResult DangKySuKien(int IDSuKien) { var ses = (DoanVienSave)Session[Constant.CUS_SESSION]; var lst = (from a in db.DangKies where a.IDSuKien == IDSuKien && a.IDDoanVien == ses.ID select new DoanVienModel { HoTen = a.DoanVien.HoTen, ID = a.DoanVien.ID, NgaySinh = a.DoanVien.NgaySinh.ToShortDateString(), DiaChi = a.DoanVien.DiaChi, NgayVaoDoan = a.DoanVien.NgayVaoDoan.ToShortDateString(), Email = a.DoanVien.Email, GioiTinh = a.DoanVien.GioiTinh ? "Nam" : "Nữ", SoDienThoai = a.DoanVien.SoDienThoai }).ToList(); if (lst.Count > 0) { return(Json(false, JsonRequestBehavior.AllowGet)); } else { DangKy dk = new DangKy { IDDoanVien = ses.ID, IDSuKien = IDSuKien, NgayDangKy = DateTime.Now }; db.DangKies.InsertOnSubmit(dk); db.SubmitChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { DangKy dk = new DangKy(); dk.Show(); this.Hide(); }
private void btnInBienLai_Click(object sender, EventArgs e) { if (isSave) { frmReport frm = new frmReport(); DANGKY d = DangKy.Select(maHV, maKH, maPhieu); List <ReportParameter> _params = new List <ReportParameter>() { new ReportParameter("CenterName", GlobalSettings.CenterName), new ReportParameter("CenterWebsite", GlobalSettings.CenterWebsite), new ReportParameter("MaHV", maHV), new ReportParameter("TenHV", d.HOCVIEN.TenHV), new ReportParameter("TenKH", d.KHOAHOC.TenKH), new ReportParameter("HocPhi", ((decimal)d.KHOAHOC.HocPhi).ToString("C0")), new ReportParameter("DaDong", ((decimal)d.PHIEUGHIDANH.DaDong).ToString("C0")), new ReportParameter("ConNo", ((decimal)d.PHIEUGHIDANH.ConNo).ToString("C0")), }; frm.ReportViewer.LocalReport.ReportEmbeddedResource = "QuanLyHocVien.Reports.rptBienLaiHocPhi.rdlc"; frm.ReportViewer.LocalReport.SetParameters(_params); frm.ReportViewer.LocalReport.DisplayName = "Biên lai học phí"; frm.Text = "Biên lai học phí"; frm.ShowDialog(); } else { MessageBox.Show("Vui lòng lưu phiếu trước khi in", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public async Task <ActionResult <bool> > PostThanhVienModel(DangKy val) { ThanhVienModel thanhVien = new ThanhVienModel(); thanhVien.Ten = val.name; thanhVien.MatKhau = StringProcessing.CreateMD5Hash(val.password); thanhVien.TaiKhoan = val.username; thanhVien.GioiTinh = val.sex; thanhVien.SDT = val.phone; thanhVien.Email = val.email; thanhVien.TrangThai = true; thanhVien.HinhAnh = "not available"; if (!UsernameExists(thanhVien.TaiKhoan)) { _context.tb_ThanhVien.Add(thanhVien); await _context.SaveChangesAsync(); } else { return(false); } var str = JsonConvert.SerializeObject(thanhVien); HttpContext.Session.SetString("user", str); if (str != null) { return(true); } return(false); }
public async Task <IActionResult> Edit(string id, [Bind("Mahp,Mssv")] DangKy dangKy) { if (id != dangKy.Mahp) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(dangKy); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DangKyExists(dangKy.Mahp)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } ViewData["Mahp"] = new SelectList(_context.HocPhan, "Mahp", "Mahp", dangKy.Mahp); ViewData["Mssv"] = new SelectList(_context.SinhVien, "Mssv", "Mssv", dangKy.Mssv); return(View(dangKy)); }
public JsonResult dangky_kichhoat(string param) { if (param.Length > 0) { if (new LopHoc().Activate(param) > 0) { List <DangKy> l_DangKy = new DangKy().GetList(param, 0, "", ""); if (l_DangKy != null && l_DangKy.Count > 0) { foreach (var item in l_DangKy) { CommonFunc.SendMail("*****@*****.**", "quy_than", item.Email, "Thông báo đăng ký học thành công", "Thông báo đăng ký học thành công", "Thông báo đăng ký học thành công"); } } List <DangKy> l_HocVien = new DangKy().GetList("", 0, "", ""); return(Json(l_HocVien, JsonRequestBehavior.AllowGet)); } else { return(null); } } else { return(null); } }
public void insert(DangKy dk) { string cn = "Server=ltp1305.mssql.somee.com;Database=ltp1305;User Id=TheMadKitten_SQLLogin_1;Password=66rbhow211;"; con = new SqlConnection(cn); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "st_dangkykh"; cmd.Parameters.Add("@hotenkh", System.Data.SqlDbType.NVarChar, 50).Value = dk.hotenkh; cmd.Parameters.Add("@diachikh", System.Data.SqlDbType.NVarChar, 100).Value = dk.diachikh; cmd.Parameters.Add("@dienthoaikh", System.Data.SqlDbType.NVarChar, 50).Value = dk.dienthoaikh; cmd.Parameters.Add("@tendn", System.Data.SqlDbType.NVarChar, 50).Value = dk.tendn; cmd.Parameters.Add("@matkhau", System.Data.SqlDbType.NVarChar, 50).Value = dk.matkhau; cmd.Parameters.Add("@ngaysinh", System.Data.SqlDbType.SmallDateTime).Value = dk.ngaysinh; cmd.Parameters.Add("@gioitinh", System.Data.SqlDbType.NVarChar, 50).Value = dk.gioitinh; cmd.Parameters.Add("@email", System.Data.SqlDbType.NVarChar, 50).Value = dk.email; cmd.Parameters.Add("@matkhauthat", System.Data.SqlDbType.NVarChar, 50).Value = dk.matkhauthat; cmd.Parameters.Add("@quyen", System.Data.SqlDbType.Int, 50).Value = dk.quyen; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void update(DangKy dk) { string cn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|QLBansach_Data.mdf;Integrated Security=True;User Instance=True"; con = new SqlConnection(cn); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "st_capnhatkh"; cmd.Parameters.Add("@makh", System.Data.SqlDbType.Int, 50).Value = dk.makh; cmd.Parameters.Add("@hotenkh", System.Data.SqlDbType.NVarChar, 50).Value = dk.hotenkh; cmd.Parameters.Add("@diachikh", System.Data.SqlDbType.NVarChar, 100).Value = dk.diachikh; cmd.Parameters.Add("@dienthoaikh", System.Data.SqlDbType.NVarChar, 50).Value = dk.dienthoaikh; cmd.Parameters.Add("@tendn", System.Data.SqlDbType.NVarChar, 50).Value = dk.tendn; cmd.Parameters.Add("@matkhau", System.Data.SqlDbType.NVarChar, 50).Value = dk.matkhau; cmd.Parameters.Add("@ngaysinh", System.Data.SqlDbType.SmallDateTime).Value = dk.ngaysinh; cmd.Parameters.Add("@gioitinh", System.Data.SqlDbType.NVarChar, 50).Value = dk.gioitinh; cmd.Parameters.Add("@email", System.Data.SqlDbType.NVarChar, 50).Value = dk.email; cmd.Parameters.Add("@matkhauthat", System.Data.SqlDbType.NVarChar, 50).Value = dk.matkhauthat; cmd.Parameters.Add("@quyen", System.Data.SqlDbType.Int, 50).Value = dk.quyen; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
private void btnDangKy_Click(object sender, EventArgs e) { DangKy dangKy = new DangKy(); this.Hide(); dangKy.ShowDialog(); this.Close(); }
public void OnePlusOneEqualTwo() { //DangKy dk = new DangKy(); Assert.AreEqual(false, DangKy.CheckPassword("thusang@123")); Assert.AreEqual(false, DangKy.CheckPassword("thusang123")); Assert.AreEqual(false, DangKy.CheckPassword("")); Assert.AreEqual(true, DangKy.CheckPassword("Thusang@123")); }
//ham xoa Dang ky public bool XoaDangKy(DangKy dk) { string sql = "delete DangKy where maDK = @maDK"; SqlParameter[] sqlParameters = { new SqlParameter("@maDK", dk.maDK) }; return(dal.myExecute(sql, sqlParameters)); }
private void cbxMaHV_TextChanged(object sender, EventArgs e) { DangKy dk = new DangKy(); DataTable tb_dk = new DataTable(); tb_dk = dk.getByMaHV(AccountHelper.getAccountId(), AccountHelper.getAccoutPassword(), cbxMaHV.Text); cbxMaLop.DataSource = tb_dk; cbxMaLop.DisplayMember = tb_dk.Columns[1].ToString(); cbxMaLop.ValueMember = tb_dk.Columns[1].ToString(); }
public async Task <IActionResult> Edit(DangKy dangky) { if (ModelState.IsValid) { _db.Update(dangky); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(dangky)); }
public DangKy[] getList_DangKy() { DataTable table = da.Query("select dk.ma, dk.ngaydangky, Khach.ten as [tenkhach], dk.ngayden, dk.gioden, dk.ngaydi, " + " dk.giodi, Phong.sophong as [sophong], dk.tiendatcoc, NhanVien.ten as [tennhanvien] " + " from dangky dk inner join Khach on dk.khachma = Khach.ma " + " inner join NhanVien on NhanVien.ma = dk.nhanvienma " + " inner join Phong on Phong.ma = dk.phongma " + " group by dk.ma, dk.ngaydangky, Khach.ten, dk.ngayden, dk.gioden, dk.ngaydi,dk.giodi, " + " Phong.sophong, dk.tiendatcoc, NhanVien.ten "); int n = table.Rows.Count; int i; if (n == 0) { return(null); } DangKy[] list = new DangKy[n]; DangKy dk = new DangKy(); DateTime date = DateTime.Now; for (i = 0; i < n; i++) { dk = new DangKy(); dk.Ma = table.Rows[i]["ma"].ToString().Trim(); if (DateTime.TryParse(table.Rows[i]["ngaydangky"].ToString().Trim(), out date)) { dk.NgayDangKy = date; } dk.KhachMa = table.Rows[i]["tenkhach"].ToString().Trim(); date = DateTime.Now; if (DateTime.TryParse(table.Rows[i]["ngayden"].ToString().Trim(), out date)) { dk.NgayDen = date; } date = DateTime.Now; dk.GioDen = int.Parse(table.Rows[i]["gioden"].ToString().Trim()); if (DateTime.TryParse(table.Rows[i]["ngaydi"].ToString().Trim(), out date)) { dk.NgayDi = date; } dk.GioDi = int.Parse(table.Rows[i]["giodi"].ToString().Trim()); dk.TienDatCoc = double.Parse(table.Rows[i]["tiendatcoc"].ToString().Trim()); dk.NhanVienMa = table.Rows[i]["tennhanvien"].ToString().Trim(); dk.PhongMa = table.Rows[i]["sophong"].ToString().Trim(); list[i] = dk; } return(list); }
private void EnrolUsers(int suspend) { SaveCheckedValues(); grvUser.AllowPaging = false; grvUser.DataBind(); DCVimaruDataContext dc = new DCVimaruDataContext(); //get courseId ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(cboFilterCourse.SelectedValue)); int courseId = Convert.ToInt32(tkb.Id); //role: Học viên int roleId = 5; MoodleEnrol enrol; XmlDocument doc = new XmlDocument(); ArrayList arrIDs = ConvertToArrayList(txtMaSV.Text); string MaSV = "0"; foreach (GridViewRow row in grvUser.Rows) { MaSV = grvUser.DataKeys[row.RowIndex]["MaSV"].ToString(); if (arrIDs.Contains(MaSV)) { CheckBox chk = row.Cells[4].Controls[0] as CheckBox; if (row.Cells[3].Text == "0" || (suspend == 0 && chk.Checked) || (suspend == 1 && !chk.Checked)) { continue; } enrol = new MoodleEnrol { RoleId = roleId, UserId = Convert.ToInt32(row.Cells[3].Text), CourseId = courseId, TimeStart = 0, TimeEnd = 0, Suspend = suspend }; List <MoodleEnrol> list = new List <MoodleEnrol>(); list.Add(enrol); doc.LoadXml(MoodleEnrol.EnrolUsers(list, (string)Session["token"])); doc.Save("D:\\enrol_" + enrol.UserId + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { DangKy dk = dc.DangKies.Single(t => t.STT == Convert.ToInt64(row.Cells[2].Text)); dk.GhiDanh = !chk.Checked; dc.SubmitChanges(); } } } grvUser.AllowPaging = true; }
public async Task <IActionResult> Create([Bind("Mahp,Mssv")] DangKy dangKy) { if (ModelState.IsValid) { _context.Add(dangKy); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewData["Mahp"] = new SelectList(_context.HocPhan, "Mahp", "Mahp", dangKy.Mahp); ViewData["Mssv"] = new SelectList(_context.SinhVien, "Mssv", "Mssv", dangKy.Mssv); return(View(dangKy)); }
//ham them Dang Ky public bool ThemDangKy(DangKy dk) { string sql = "insert into DangKy(maDK, maSV, maHP, hocKyNamHoc, dongTien)" + "values (@maDK, @maSV, @maHP, @hocKyNamHoc, @dongTien)"; SqlParameter[] sqlParameters = { new SqlParameter("@maDK", dk.maDK), new SqlParameter("@maSV", dk.maSV), new SqlParameter("@maHP", dk.maHP), new SqlParameter("@hocKyNamHoc", dk.hocKyNamHoc), new SqlParameter("@dongTien", dk.dongTien) }; return(dal.myExecute(sql, sqlParameters)); }
public bool delete(long id) { try { DangKy temp = db.DangKies.Find(id); db.DangKies.Remove(temp); db.SaveChanges(); return(true); } catch { return(false); } }
//ham sua DangKy public bool SuaDangKy(DangKy dk) { string sql = "Update DangKy set maSV = @maSV, maHP = @maHP, hocKyNamHoc = @hocKyNamHoc, dongTien = @dongTien where maDK = @maDK"; SqlParameter[] sqlParameters = { new SqlParameter("@maDK", dk.maDK), new SqlParameter("@maSV", dk.maSV), new SqlParameter("@maHP", dk.maHP), new SqlParameter("@hocKyNamHoc", dk.hocKyNamHoc), new SqlParameter("@dongTien", dk.dongTien) }; return(dal.myExecute(sql, sqlParameters)); }
private void btnDangKy_Click(object sender, EventArgs e) { bool kayit; bool ktuser; bool ktmanv; DangKy DK = new DangKy(); DK.DK_hotenNV = txtHoTen.Text; DK.DK_maNVFT = txtMaNV.Text; DK.DK_user = txtUser.Text; DK.DK_pass = txtPassword.Text; DK.DK_xnpass = txtXNpass.Text; kayit = DK.saveDangky(); ktmanv = DK.saveDangky(); ktuser = DK.saveDangky(); //if ( trim (txtMaNV.Text) = "") // MessageBox.Show("Chưa nhập mã nhân viên!"); if (kayit == false) { MessageBox.Show("Username đã được sử dụng"); } else if (ktuser == false) { MessageBox.Show("Nhân Viên đã có tài khoản"); } else if (ktmanv == false) { MessageBox.Show("Nhân Viên không tồn tại"); } else { if (txtPassword.Text == txtXNpass.Text) { MessageBox.Show("Đăng ký thành công"); } else { MessageBox.Show("Password chưa đúng"); } } txtHoTen.Text = ""; txtMaNV.Text = ""; txtUser.Text = ""; txtPassword.Text = ""; txtXNpass.Text = ""; }
public bool CapNhatDK(DangKy DangKy) { try { var kq = db.DangKies.Find(DangKy.ID_DangKy); kq.NgayXem = kq.NgayXem; kq.TrangThai = kq.TrangThai; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public long Add(DangKy entity) { try { db.DangKies.Add(entity); db.SaveChanges(); } catch (Exception) { return(0); throw; } return(entity.ID); }
public int hocvien_dangky(string HoTen, byte Tuoi, string DiaChi, string Email, string SDT, short LopHocID, string Username, string Password) { DangKy dk = new DangKy(); dk.DiaChi = DiaChi; dk.HoTen = HoTen; dk.SDT = SDT; dk.Email = Email; dk.Tuoi = Tuoi; dk.LopHocID = LopHocID; dk.Username = Username; dk.Password = md5.getMd5(Password); dk.IP = CommonFunc.getIPAddress(); return(dk.Add()); }
public void delete(DangKy dk) { string cn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|QLBansach_Data.mdf;Integrated Security=True;User Instance=True"; con = new SqlConnection(cn); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "st_xoakh"; cmd.Parameters.Add("@makh", System.Data.SqlDbType.Int, 50).Value = dk.makh; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
/// <summary> /// Kiểm tra phiếu ghi danh có hợp lệ /// </summary> public void ValidatePhieu() { var f = DangKy.SelectAll(gridDSHV.SelectedRows[0].Cells["clmMaHV"].Value.ToString()); foreach (var i in f) { if (i.PHIEUGHIDANH.ConNo > 0) { throw new Exception("Học viên đang nợ không được phép ghi danh mới"); } } if (numDaDong.Value < GlobalSettings.QuyDinh["QD0001"]) { throw new Exception(string.Format("Số tiền đóng khi ghi danh phải ít nhất bằng {0:C0}", GlobalSettings.QuyDinh["QD0001"])); } }
public IActionResult CreateDangKy(string madailycreate, string idvesocreate, int soluongdangkycreate) { DaiLy daily = context.DaiLy.Where(dl => dl.MaDaiLy == madailycreate).SingleOrDefault(); DangKy dangky = new DangKy(); dangky.Id = Guid.Parse(Guid.NewGuid().ToString().ToUpper()); dangky.IdDaiLy = daily.Id; dangky.IdLoaiVeSo = Guid.Parse(idvesocreate.ToUpper()); dangky.NgayDangKy = DateTime.Now; dangky.SoLuong = soluongdangkycreate; context.DangKy.Add(dangky); context.SaveChanges(); string thongbao = "Thêm thành công"; return(RedirectToAction("Index", "DaiLy", new { thongbao = thongbao })); }
public bool Edit(DangKy entity) { try { DangKy temp = db.DangKies.Find(entity.ID); temp.HocPhi = entity.HocPhi; temp.HocSinhID = entity.HocSinhID; temp.LopID = entity.LopID; temp.NgayDky = entity.NgayDky; temp.NguoiDangKy = entity.NguoiDangKy; db.SaveChanges(); return(true); } catch { return(false); } }
protected void btnAddGroupMember_Click(object sender, EventArgs e) { SaveCheckedValues(); grvUser.AllowPaging = false; grvUser.DataBind(); DCVimaruDataContext dc = new DCVimaruDataContext(); //get group Id int groupId = Convert.ToInt32(cboGroup.SelectedValue); //get user list XmlDocument doc = new XmlDocument(); ArrayList arrIDs = ConvertToArrayList(txtMaSV.Text); string MaSV = "0"; foreach (GridViewRow row in grvUser.Rows) { MaSV = grvUser.DataKeys[row.RowIndex]["MaSV"].ToString(); if (arrIDs.Contains(MaSV)) { CheckBox chk = row.Cells[4].Controls[0] as CheckBox; if (row.Cells[3].Text == "0" || !chk.Checked || row.Cells[10].Text != " ") { continue; } List <KeyValuePair <int, int> > list = new List <KeyValuePair <int, int> >(); list.Add(new KeyValuePair <int, int>(groupId, Convert.ToInt32(row.Cells[3].Text))); doc.LoadXml(MoodleGroup.AddGroupMembers(list, (string)Session["token"])); doc.Save("D:\\Group_Add_Member_" + cboGroup.Text + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { DangKy dk = dc.DangKies.Single(t => t.STT == Convert.ToInt64(row.Cells[2].Text)); dk.ID_Nhom = (long?)groupId; dc.SubmitChanges(); } } } grvUser.AllowPaging = true; }
public JsonResult dangky_xoa(string param) { if (param.Length > 0) { if (new LopHoc().Delete(param) > 0) { List <DangKy> l_HocVien = new DangKy().GetList("", 0, "", ""); return(Json(l_HocVien, JsonRequestBehavior.AllowGet)); } else { return(null); } } else { return(null); } }
public bool DatPhong(DangKy dk) { /*proc_insert_DatPhong](@khachma varchar(20), @phongma varchar(20),@ngaydangky date, @ngayden date, @gioden int, * @ngaydi date, @giodi int, @tiendatcoc money , @nhanvienma varchar(20)*/ SqlParameter[] para = { //([proc_insert_DatPhong](@khachma varchar(20), @phongma varchar(20),@ngaydangky date, @ngayden date, @gioden int, //@ngaydi date, @giodi int, @tiendatcoc money , @nhanvienma varchar(20)) new SqlParameter("khachma", dk.KhachMa), new SqlParameter("phongma", dk.PhongMa), new SqlParameter("ngaydangky", dk.NgayDangKy), new SqlParameter("ngayden", dk.NgayDen), new SqlParameter("gioden", dk.GioDen), new SqlParameter("ngaydi", dk.NgayDi), new SqlParameter("giodi", dk.GioDi), new SqlParameter("tiendatcoc", dk.TienDatCoc), new SqlParameter("nhanvienma", dk.NhanVienMa) }; da.Query("proc_insert_DatPhong", para); return(true); }
private void bt_DangKy_Click(object sender, EventArgs e) { DangKy dk = new DangKy(this); dk.Show(); }