public ActionResult Delete(string key, string json) { var msg = new JsonMessage(false, "Xóa dữ liệu thành công."); var pictureId = Request["Value_DefaultImages"]; try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } var model = _da.GetById(ItemId); model.IsDeleted = true; _da.Save(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); msg.Erros = true; msg.Message = "Dữ liệu chưa được xóa"; } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(string key, string json) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } var model = _da.GetById(ItemId); UpdateModel(model); model.Name = HttpUtility.UrlDecode(model.Name); _da.Save(); } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu Chưa được cập nhật."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(string key, Guid userId) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } var model = _da.GetById(ItemId); UpdateModel(model); model.UserUpdate = userId; _da.Save(); } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật"; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(string key, string code, string json, int id) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key == Keyapi) { var departmentItem = JsonConvert.DeserializeObject <DepartmentItem>(json); var obj = _da.GetById(id); departmentItem.AgencyID = Agencyid(); UpdateBase(obj, departmentItem); _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật"; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
private void ChonSinhVien() { try { var save = new SqlBulkCopy(); var tbxp = save.tbXepPhong(); foreach (var row in dgv_DanhSach.Rows) { if (!bool.Parse(row.Cells["Chon"].Text)) { continue; } tbxp.Rows.Add(row.Cells["MaSV"].Text, _idkythi); } save.Bulk_Insert("XEPPHONG", tbxp); Invoke((Action)(() => MessageBox.Show(@"Lưu lại thành công", @"Thông báo"))); Invoke((Action)(Close)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void SuaDiem() { try { var frm = new FrmSuaDiemThi(_idKyThi) { update = false, txtmasv = { Text = dgv_DanhSach.ActiveRow.Cells["MaSV"].Text }, txtmade = { Text = dgv_DanhSach.ActiveRow.Cells["MaDe"].Text }, txtchuoi = { Text = dgv_DanhSach.ActiveRow.Cells["KetQua"].Text } }; frm.ShowDialog(); if (frm.update) { dgv_DanhSach.ActiveRow.Cells["MaDe"].Value = frm.txtmade.Text; dgv_DanhSach.ActiveRow.Cells["KetQua"].Value = frm.txtchuoi.Text; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Add(string key, string json) { var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công."); var model = new TemplateDocument(); try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } UpdateModel(model); _da.Add(model); _da.Save(); } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu Chưa được thêm mới."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public void Napdulieu() { try { var frmNapDuLieu = new FrmNapDuLieu(GetTable(), _idKyThi) { ViTriHeader = 1 }; frmNapDuLieu.ShowDialog(); var resultValue = frmNapDuLieu.ResultValue; if (resultValue == null || resultValue.Rows.Count == 0) { return; } var frm = new FrmImportDapAn(resultValue); frm.ShowDialog(); Huy(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void InPhong() { try { if (string.IsNullOrEmpty(txttuphong.Text)) { txttuphong.Focus(); } else if (string.IsNullOrEmpty(txtdenphong.Text)) { txtdenphong.Focus(); } else { update = true; Close(); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
protected override void LoadFormDetail() { try { var tb = SearchData.KtraChamThi(_idkythi); if (tb.Rows.Count > 0) { if (DialogResult.No == MessageBox.Show(@"Bài thi của sv đã được chấm bạn có muốn chấm lại không.", FormResource.MsgCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { dgv_DanhSach.DataSource = tb; pnl_from.Visible = true; return; } } var thread = new Thread(LoadGrid) { IsBackground = true }; thread.Start(); OnShowDialog("Loading..."); if (_tbError.Rows.Count > 0) { var text = @"Còn " + _tbError.Rows.Count + @" bài thi chưa được chấm"; var frm = new FrmMsgImportSv(text, _tbError, 2); frm.ShowDialog(); } pnl_from.Visible = true; } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void Rptbangdiem() { try { var frm = new FrmRptBangDiem { bUpdate = false }; frm.ShowDialog(); if (!frm.bUpdate) { return; } _masv = frm.Masv; var tb = LoadData.LoadBangdiem(int.Parse(frm.Masv)); if (tb.Rows.Count > 0) { reportManager1.DataSources.Clear(); reportManager1.DataSources.Add("danhsach", tb); rptbangdiem.FilePath = Application.StartupPath + @"\Reports\bangdiem.rst"; rptbangdiem.Prepare(); rptbangdiem.GetReportParameter += GetParameter; var previewForm = new PreviewForm(rptbangdiem) { WindowState = FormWindowState.Maximized }; previewForm.Show(); } else { MessageBox.Show(@"Sai mã sinh viên", @"Thông báo"); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Update(string key, Guid userId) { var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công."); try { if (key == Keyapi) { var model = _da.GetbyId(ItemId); UpdateModel(model); var lsttmp = Request["lstDetail"]; var lst = Request["lstCate"]; model.Category_Recipe.Clear(); if (!string.IsNullOrEmpty(lst)) { model.Category_Recipe = _da.GetListArrIdCateRecipe(lst); } model.ProductDetail_Recipe.Clear(); if (!string.IsNullOrEmpty(lsttmp)) { model.ProductDetail_Recipe = _da.GetListArrIdDetailRecipe(lsttmp); } _da.Save(); } else { msg = new JsonMessage(true, "Có lỗi xảy ra!."); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được thêm mới."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
protected override void DeleteRow() { try { DeleteRowGrid(dgv_DanhSach, "ID", "TenPhong"); if (IdDelete.Count <= 0) { return; } foreach (var i in IdDelete) { var xp = new XepPhong { IdKyThi = _idkythi, IdPhong = i }; var ktp = new KTPhong { IdKyThi = _idkythi, IdPhong = i }; _listXepPhong.Add(xp); _listKtPhong.Add(ktp); } DeleteData.XoaKtPhong(_listKtPhong); UpdateData.UpdateXepPhongNull(_listXepPhong); MessageBox.Show(FormResource.MsgThongbaothanhcong, FormResource.MsgCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); LoadGrid(); IdDelete.Clear(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
/// <summary> /// Thống kê sinh viên theo điểm /// </summary> /// <returns></returns> private static string GetstrThongke(IList <int> list) { var tb = new DataTable(); try { var str = new string[list.Count]; var strselect = "select "; for (var i = 0; i < list.Count; i++) { str[i] = "(select MaSV, DiemThi from BAILAM where DiemThi is not null and IdKyThi = " + list[i] + " ) a" + i; } var strtong = "(a0.DiemThi"; for (var i = 1; i < list.Count; i++) { strtong = strtong + "+ a" + i + ".DiemThi"; } strselect = strselect + strtong + ") as [TongDiem] "; var strjointable = str[0]; for (var i = 1; i < list.Count; i++) { strjointable = strjointable + " join " + str[i] + " on a" + (i - 1) + ".MaSV = a" + i + ".MaSV "; } var strend = strselect + " FROM " + strjointable; return(strend); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(null); } }
// áp dụng nhiều kỳ thi public static DataTable[] KiemTraLogic(IList <int> list) { var tb = new DataTable[list.Count]; try { var str = new string[list.Count]; for (var i = 0; i < list.Count; i++) { str[i] = "select bl.MaSV,s.HoSV,s.TenSV,s.NgaySinh,l.MaLop, p.TenPhong" + " from BAILAM bl join XEPPHONG x on bl.MaSV = x.IdSV join SINHVIEN s on bl.MaSV = s.MaSV join LOP l on s.IdLop = l.ID join PHONGTHI p on x.IdPhong = p.ID" + " where IdKyThi = " + list[i] + " and not exists( select c.MaSV From (" + Getstr2(list) + " ) c where bl.MaSV = c.MaSV)"; tb[i] = Conn.GetTable(str[i]); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(tb); }
private void Rptdsbailam() { try { if (dgv_DanhSach.Rows.Count == 0) { return; } reportManager1.DataSources.Clear(); reportManager1.DataSources.Add("danhsach", dgv_DanhSach.DataSource); rptdsbailam.FilePath = Application.StartupPath + @"\Reports\dsbailam.rst"; rptdsbailam.Prepare(); rptdsbailam.GetReportParameter += GetParameter; var previewForm = new PreviewForm(rptdsbailam) { WindowState = FormWindowState.Maximized }; previewForm.Show(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
protected override void LoadFormDetail() { try { var frm = new FrmGopKetQua { Check = false }; frm.ShowDialog(); _list = frm.LstIdKyThi; if (_list.Count > 0 && frm.Check) { var thread = new Thread(LoadGrid) { IsBackground = true }; thread.Start(); OnShowDialog("Loading..."); } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
private void txtPathBackup_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { try { var openfiledialog = new OpenFileDialog { Filter = @"Excel Files|*.bak;*bak", Multiselect = false, Title = @"Chọn file bak", CheckFileExists = true, CheckPathExists = true }; if (openfiledialog.ShowDialog() == DialogResult.OK) { _str = openfiledialog.FileName; txtPathBackup.Text = _str; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult UpdateCustomerCare(string key, string json, int agencyId) { var msg = new JsonMessage(false, "Sở thích cập nhật thành công."); try { if (key != Keyapi) { return(Json(0, JsonRequestBehavior.AllowGet)); } var model = _da.GetById(ItemId); var NoteCate = Request["NoteCate"]; var customerCare = model.Customer_Care.Where(v => v.AgencyId == agencyId).FirstOrDefault(); if (customerCare != null) { customerCare.Note = HttpUtility.UrlDecode(NoteCate); } else { customerCare = new Customer_Care { Note = HttpUtility.UrlDecode(NoteCate), AgencyId = Agencyid() }; model.Customer_Care.Add(customerCare); } _da.Save(); } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật"; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
private void dgv_DanhSach_InitializeLayout(object sender, InitializeLayoutEventArgs e) { try { var band = e.Layout.Bands[0]; band.Columns["IdKyThi"].Hidden = true; band.Columns["ThangDiem"].Hidden = true; band.Override.CellAppearance.TextHAlign = HAlign.Center; band.Override.HeaderAppearance.FontData.SizeInPoints = 10; band.Override.HeaderAppearance.FontData.Bold = DefaultableBoolean.True; band.Columns["MaMon"].MinWidth = 140; band.Columns["MaDe"].MinWidth = 140; band.Columns["CauHoi"].MinWidth = 140; band.Columns["Dapan"].MinWidth = 140; band.Columns["MaMon"].MaxWidth = 150; band.Columns["MaDe"].MaxWidth = 150; band.Columns["CauHoi"].MaxWidth = 150; band.Columns["Dapan"].MaxWidth = 150; band.Override.HeaderClickAction = HeaderClickAction.SortSingle; #region Caption band.Columns["MaMon"].Header.Caption = @"Mã môn thi"; band.Columns["MaDe"].Header.Caption = @"Mã đề thi"; band.Columns["CauHoi"].Header.Caption = @"Câu hỏi"; band.Columns["Dapan"].Header.Caption = @"Đáp án"; #endregion } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public static DataTable Timkiemnienkhoa3(int i, string id, int idkhoa, int idlop) { try { string str = null; switch (i) { case 1: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and l.ID = " + idlop + " and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV"; break; case 2: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and k.ID = " + idkhoa + " and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV"; break; case 3: str = "SELECT ROW_NUMBER() OVER(ORDER BY l.MaLop, s.TenSV) as [STT],s.MaSV,s.HoSV,s.TenSV,s.NgaySinh," + "s.IdLop,l.MaLop,l.IdKhoa,k.TenKhoa " + "FROM SINHVIEN s,LOP l, KHOA k " + "WHERE s.IdLop = l.ID and l.IdKhoa = k.ID and s.MaSV like '%" + id + "' ORDER BY l.MaLop, s.TenSV"; break; } return(Conn.GetTable(str)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(null); } }
/// <summary> /// Tìm kiếm sv theo niên khóa mục quản lý sinh viên /// </summary> /// <returns>trả về bảng sinh viên</returns> public static DataTable Timkiemnienkhoa(int i, string id, int idkythi, int idkhoa, int idlop) { try { string str = null; switch (i) { case 1: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " + "FROM SINHVIEN s,LOP l WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " + "and s.IdLop = l.ID and l.ID = " + idlop + " and s.MaSV like '%" + id + "' ORDER BY TenSV"; break; case 2: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " + "FROM SINHVIEN s,LOP l, KHOA k WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " + "and s.IdLop = l.ID and l.IdKhoa = k.ID and k.ID = " + idkhoa + " and s.MaSV like '%" + id + "' ORDER BY TenSV"; break; case 3: str = "SELECT ROW_NUMBER() OVER(ORDER BY s.TenSV) as [STT], s.MaSV, s.HoSV, s.TenSV, s.NgaySinh, l.MaLop,'false' as [Chon] " + "FROM SINHVIEN s,LOP l WHERE not exists (SELECT x.IdSV FROM XEPPHONG x WHERE x.IdSV = s.MaSV and x.IdKyThi = " + idkythi + ") " + "and s.IdLop = l.ID and s.MaSV like '%" + id + "' ORDER BY TenSV"; break; } return(Conn.GetTable(str)); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); return(null); } }
/// <summary> /// Hàm lấy dữ liệu từ file excel /// </summary> public void Napdulieu() { try { var frmNapDuLieu = new FrmNDLSinhVien(GetTable(), 1); frmNapDuLieu.ShowDialog(); var resultValue = frmNapDuLieu.ResultValue; var tbsvError = _save.sp_checkData("sp_CheckSV", "@tbl", resultValue); if (resultValue == null || resultValue.Rows.Count == 0) { return; } if (tbsvError.Rows.Count > 0) { var text = @"Thao tác không hoành thành vì có " + tbsvError.Rows.Count + @" sv đăng ký dự thi chưa có trong từ điển"; MessageBox.Show(text, FormResource.MsgCaption); RptView("danhsachsinhvien", tbsvError); } else { var tbxp = _save.tbXepPhong(); foreach (DataRow row in resultValue.Rows) { tbxp.Rows.Add(row["MaSV"], _idkythi); } _save.sp_InsertUpdate("sp_InsertXepPhong", "@tbl", tbxp); LoadGrid(); MessageBox.Show(tbxp.Rows.Count + @" Sinh viên đã được inport thành công."); } } catch (Exception ex) { MessageBox.Show(@"Thao tác thất bại", FormResource.MsgCaption); Log2File.LogExceptionToFile(ex); } }
public ActionResult Delete(string key, string listint) { var msg = new JsonMessage(false, "Xóa dữ liệu thành công."); try { if (key == Keyapi) { var list = _da.GetListByArrId(listint); foreach (var item in list) { item.IsDelete = true; } _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được xóa."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult UnLockAgency(string key, string lstInt) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key == Keyapi) { var obj = _da.GetListByArrId(lstInt); foreach (var item in obj) { item.IsLock = false; } _da.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Register(CustomerItem customer) { var objr = new CustomerAppItem { Status = 0 }; try { if (!string.IsNullOrEmpty(customer.Phone) && !string.IsNullOrEmpty(customer.Password)) { if (_da.CheckUserName(customer.Phone)) { return(Json(new BaseResponse <CustomerItem>() { Erros = true, Message = "Số điện thoại đã tồn tại", }, JsonRequestBehavior.AllowGet)); } var daten = DateTime.Now; var date = daten.TotalSeconds(); var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(customer.Password, saltKey); //get agencyinfo var agencyDA = new AgencyDA(); var agency = agencyDA.GetItem(customer.PhoneAgency); var obj = new Base.Customer { FullName = customer.FullName, Phone = customer.Phone, PasswordSalt = saltKey, PassWord = sha1PasswordHash, UserName = customer.UserName, DateCreated = date, IsDelete = false, IsActive = true, Reward = 0, AgencyID = agency?.ID }; _da.Add(obj); _da.Save(); IAuthContainerModel model = new JWTContainerModel() { Claims = new Claim[] { new Claim(ClaimTypes.Name, obj.UserName), new Claim("ID", obj.ID.ToString()), } }; IAuthService authService = new JWTService(); var token = authService.GenerateToken(model); var result = new BaseResponse <CustomerItem>() { Erros = false, Data = new CustomerItem() { FullName = obj.FullName, Phone = obj.Phone, Token = token } }; return(Json(result, JsonRequestBehavior.AllowGet)); var datee = daten.AddDays(5).TotalSeconds(); //var lg = new Ultils(); var code = Ultils.CodeLogin(daten); var dNlogin = new DN_Login { CustomerID = obj.ID, DateCreated = date, DateEnd = datee, Code = code, IsOut = false }; _dl.Add(dNlogin); _dl.Save(); objr = new CustomerAppItem { ID = obj.ID, Status = 1, }; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(Json(objr, JsonRequestBehavior.AllowGet)); }
/// <summary> /// /// </summary> /// <param name="key"></param> /// <param name="phone">UserName</param> /// <param name="mobile">SĐT3G</param> /// <param name="pass">Mật khẩu</param> /// <param name="address">Địa chỉ</param> /// <returns></returns> public ActionResult Addapp(string key, string phone, string mobile, string pass, string address, string name, int gid) { var objr = new CustomerAppItem { UserName = phone, Status = 0 }; try { if (key == Keyapi && !string.IsNullOrEmpty(phone) && !string.IsNullOrEmpty(pass)) { if (_da.CheckUserName(phone)) { return(Json(objr, JsonRequestBehavior.AllowGet)); } var daten = DateTime.Now; var date = daten.TotalSeconds(); var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(pass, saltKey); var obj = new Base.Customer { Address = address, FullName = name, GroupID = gid, Phone = phone, PasswordSalt = saltKey, PassWord = sha1PasswordHash, UserName = phone, DateCreated = date, IsDelete = false, IsActive = true, Reward = 0, }; _da.Add(obj); _da.Save(); var datee = daten.AddDays(5).TotalSeconds(); //var lg = new Ultils(); var code = Ultils.CodeLogin(daten); var dNlogin = new DN_Login { CustomerID = obj.ID, DateCreated = date, DateEnd = datee, Code = code, IsOut = false }; _dl.Add(dNlogin); _dl.Save(); objr = new CustomerAppItem { ID = obj.ID, UserName = phone, Address = address, FullName = name, Phone = mobile, Reward = 0, GroupID = gid, Status = 1, }; } } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } return(Json(objr, JsonRequestBehavior.AllowGet)); }
protected override void DeleteRow() { try { bool xoa = false; if (dgv_DanhSach.Selected.Rows.Count > 0) { if (DialogResult.Yes == MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { foreach (var row in dgv_DanhSach.Selected.Rows) { var masv = row.Cells["MaSV"].Text; var idPhong = row.Cells["IdPhong"].Text; if (!string.IsNullOrEmpty(idPhong)) { var ktp = new KTPhong { IdKyThi = _idkythi, IdPhong = int.Parse(idPhong) }; _listKtPhong.Add(ktp); } var xp = new XepPhong { IdKyThi = _idkythi, IdSV = int.Parse(masv) }; _listXepPhong.Add(xp); } DeleteAndUpdate = true; dgv_DanhSach.DeleteSelectedRows(false); xoa = true; } } else if (dgv_DanhSach.ActiveRow != null) { if (DialogResult.Yes == MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { var masv = dgv_DanhSach.ActiveRow.Cells["MaSV"].Text; var idPhong = dgv_DanhSach.ActiveRow.Cells["IdPhong"].Text; if (!string.IsNullOrEmpty(idPhong)) { var ktp = new KTPhong { IdKyThi = _idkythi, IdPhong = int.Parse(idPhong) }; _listKtPhong.Add(ktp); } var xp = new XepPhong { IdKyThi = _idkythi, IdSV = int.Parse(masv) }; _listXepPhong.Add(xp); DeleteAndUpdate = true; dgv_DanhSach.ActiveRow.Delete(false); xoa = true; } } UpdateData.UpdateGiamSiSo(_listKtPhong); DeleteData.XoaXepPhong(_listXepPhong); if (xoa) { MessageBox.Show(@"Xóa dữ liệu thành công.", @"Thông báo"); } LoadGrid(); } catch (Exception ex) { Log2File.LogExceptionToFile(ex); } }
public ActionResult Add(string key, string json) { var msg = new JsonMessage(false, "Thêm mới dữ liệu thành công."); try { if (key == Keyapi) { var date = DateTime.Now.TotalSeconds(); var objitem = JsonConvert.DeserializeObject <AgencyItem>(json); var obj = new DN_Agency { IsDelete = false, IsLock = false, IsOut = false, CreateDate = date, WalletValue = 10000000, CashOut = 0, }; obj = UpdateBase(obj, objitem); _da.Add(obj); _da.Save(); if (objitem.GroupID > 0) { _da.InsertDNModule(objitem.GroupID, obj.ID); } var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, saltKey); var user = new DN_Users { UserId = Guid.NewGuid(), PasswordSalt = saltKey, Password = sha1PasswordHash, UserName = objitem.UserName, LoweredUserName = obj.Name, Email = obj.Email, Address = obj.Address, AgencyID = obj.ID, Mobile = obj.Phone, IsApproved = true, IsLockedOut = false, CreateDate = date, IsDeleted = false }; _daUserDa.Add(user); _daUserDa.Save(); var role = new DN_Roles { RoleId = Guid.NewGuid(), RoleName = "Admin", LoweredRoleName = "admin", AgencyID = obj.ID, Description = "Quản trị" }; _darRoleDa.Add(role); var dnUsersInRoles = new DN_UsersInRoles { UserId = user.UserId, AgencyID = obj.ID, DateCreated = date, IsDelete = false }; role.DN_UsersInRoles.Add(dnUsersInRoles); _darRoleDa.Save(); } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được thêm mới."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(string key, string json) { var msg = new JsonMessage(false, "Cập nhật dữ liệu thành công."); try { if (key == Keyapi) { var objitem = JsonConvert.DeserializeObject <AgencyItem>(json); var obj = _da.GetById(objitem.ID); var check = obj.GroupID != objitem.GroupID; if (obj.GroupID > 0 && check) { _da.InsertDNModule(objitem.GroupID, obj.ID, true); } obj = UpdateBase(obj, objitem); _da.Save(); if (!string.IsNullOrEmpty(objitem.Pass)) { var user = _daUserDa.GetUserByUserName(objitem.UserName); if (user != null) { var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, user.PasswordSalt); user.Password = sha1PasswordHash; } else { var date = ConvertDate.TotalSeconds(DateTime.Now); var role = _darRoleDa.GetByName("Admin"); if (role == null) { role = new DN_Roles { RoleId = Guid.NewGuid(), RoleName = "Admin", LoweredRoleName = "admin", AgencyID = obj.ID, Description = "Quản trị" }; _darRoleDa.Add(role); _darRoleDa.Save(); } var saltKey = FDIUtils.CreateSaltKey(5); var sha1PasswordHash = FDIUtils.CreatePasswordHash(objitem.Pass, saltKey); user = new DN_Users { UserId = Guid.NewGuid(), PasswordSalt = saltKey, Password = sha1PasswordHash, UserName = objitem.UserName, LoweredUserName = obj.Name, Email = obj.Email, Address = obj.Address, AgencyID = obj.ID, Mobile = obj.Phone, IsApproved = true, IsLockedOut = false, CreateDate = date, IsDeleted = false }; _daUserDa.Add(user); var dnUsersInRoles = new DN_UsersInRoles { UserId = role.RoleId, AgencyID = obj.ID, DateCreated = date }; user.DN_UsersInRoles.Add(dnUsersInRoles); } _daUserDa.Save(); } } } catch (Exception ex) { msg.Erros = true; msg.Message = "Dữ liệu chưa được cập nhật."; Log2File.LogExceptionToFile(ex); } return(Json(msg, JsonRequestBehavior.AllowGet)); }