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