public TAI_KHOAN GetDVByMa(int pMa) { TAI_KHOAN result = new TAI_KHOAN(); result = context.TAI_KHOAN.FirstOrDefault(m => m.MA_TK == pMa); return(result); }
//cập nhật tiền khi thêm public void update_tien_them(PHIEU_THU p) { TAI_KHOAN tk = qlt.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault(); tk.SODUHT += p.TIEN; qlt.SubmitChanges(); }
public TAI_KHOAN GetByUsername(string username) { TAI_KHOAN result = new TAI_KHOAN(); result = context.TAI_KHOAN.FirstOrDefault(m => m.USERNAME == username); return(result); }
private void ProccessLogin() { LoginResult res = dal_login.checkUser(txtTenDangNhap.Text, txtMatKhau.Text); if (res == LoginResult.Invalid) { MessageBox.Show("Sai mật khẩu hoặc password !"); return; } if (res == LoginResult.Invalid) { MessageBox.Show("Tài khoảng bị khóa !"); return; } if (res == LoginResult.Success) { nhanVien = dal_login.getTaiKhoan(txtTenDangNhap.Text, txtMatKhau.Text); if (Program.frmMain == null || Program.frmMain.IsDisposed) { Program.frmMain = new frmMain(); } this.Visible = false; Program.frmMain.Show(); } }
private void Add() { var id = data.TAI_KHOANs.Where(u => u.TaiKhoan == txt_username.Text.Trim()).SingleOrDefault <TAI_KHOAN>(); if (id != null) { tb_thongbao.Text = "Tên Tài khoản đã tồn tại."; return; } else { try { TAI_KHOAN tk = new TAI_KHOAN(); tk.TaiKhoan = txt_username.Text; tk.MatKhau = txt_password.Text; tk.MaLoai = int.Parse(cb_loai.SelectedValue.ToString()); data.TAI_KHOANs.InsertOnSubmit(tk); data.SubmitChanges(); } catch { } finally { GetData(); } } }
protected void btn_dangky_Click(object sender, EventArgs e) { KHACH_HANG kh = new KHACH_HANG(); TAI_KHOAN tk = new TAI_KHOAN(); kh.PHONE = txt_phone.Text; kh.EMAIL = txt_email.Text; kh.TEN_KH = txt_name.Text; if (khachHangService.Add(kh) == 1) { tk.MA_KH = kh.MA_KH; tk.USERNAME = txt_username.Text; byte[] pass = Encoding.ASCII.GetBytes(txt_password.Text); tk.PASSWORD = pass; tk.TRANG_THAI = true; if (taiKhoanService.Add(tk) == 1) { lbResult.Visible = true; lbResult.Text = "Đăng ký thành công"; hyperlink.Visible = true; hyperlink.Text = "Chuyển sang trang login"; } else { lbResult.Visible = true; lbResult.Text = "Đăng ký không thành công"; } } else { lbResult.Visible = true; lbResult.Text = "Đăng ký không thành công"; } }
public int Add(TAI_KHOAN p) { int result = 0; context.TAI_KHOAN.Add(p); result = context.SaveChanges(); return(result); }
public void create_TAI_KHOAN(string tk) { TAI_KHOAN tAI_KHOAN = new TAI_KHOAN(); tAI_KHOAN.TAI_KHOAN1 = tk; tAI_KHOAN.MAT_KHAU = "123"; db.TAI_KHOAN.Add(tAI_KHOAN); db.SaveChanges(); }
public int Delete(int pMa) { int result = 0; TAI_KHOAN k = context.TAI_KHOAN.FirstOrDefault(m => m.MA_TK == pMa); context.TAI_KHOAN.Remove(k); result = context.SaveChanges(); return(result); }
// kiểm tra trùng khóa chính public int KT_KhoaChinh(string ma) { TAI_KHOAN tk = qlq.TAI_KHOANs.Where(t => t.MATK == ma).FirstOrDefault(); if (tk != null) { return(1);// trùng mã } return(0); }
public int Them_TK(TAI_KHOAN tk) { try { qlq.TAI_KHOANs.InsertOnSubmit(tk); qlq.SubmitChanges(); return(0); } catch (Exception ex) { return(1); } }
public int KT_KhoaNgoai(int ma) { TAI_KHOAN tk = qlltk.TAI_KHOANs.Where(t => t.MA_LOAI_TK == ma).FirstOrDefault(); if (tk != null) { return(1); } return(0); }
//kiểm tra khóa ngoại public int KT_KhoaNgoai(string ma) { TAI_KHOAN a = qltt.TAI_KHOANs.Where(t => t.MALOAI == ma).FirstOrDefault(); if (a != null)// { return(1); } return(0); }
public ActionResult DeleteConfirmed(string id) { GIAO_VIEN gIAO_VIEN = db.GIAO_VIEN.Find(id); db.GIAO_VIEN.Remove(gIAO_VIEN); TAI_KHOAN tAI_KHOAN = db.TAI_KHOAN.Find(id); db.TAI_KHOAN.Remove(tAI_KHOAN); db.SaveChanges(); return(RedirectToAction("Index")); }
//update tien khi cap nhat public int update_tien_lan2(string matk, decimal?tiencu, decimal?tienmoi) { try { TAI_KHOAN tk = qlt.TAI_KHOANs.Where(t => t.MATK == matk).FirstOrDefault(); tk.SODUHT = tk.SODUHT - tiencu + tienmoi; qlt.SubmitChanges(); return(1); } catch (Exception ex) { return(0); } }
//xóa phiếu chi public int Xoa_PhieuThu(string ma) { try { PHIEU_THU p = qlt.PHIEU_THUs.Where(t => t.MAPTHU == ma).FirstOrDefault(); TAI_KHOAN tk = qlt.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault(); tk.SODUHT -= p.TIEN; qlt.PHIEU_THUs.DeleteOnSubmit(p); qlt.SubmitChanges(); return(0); } catch (Exception ex) { return(1); } }
//xóa phiếu chi public int Xoa_PhieuChi(string ma) { try { PHIEU_CHI p = qlc.PHIEU_CHIs.Where(t => t.MA_PCHI == ma).FirstOrDefault(); TAI_KHOAN tk = qlc.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault(); tk.SODUHT += p.SO_TIEN; qlc.PHIEU_CHIs.DeleteOnSubmit(p); qlc.SubmitChanges(); return(0); } catch (Exception ex) { return(1); } }
public int Update(TAI_KHOAN p) { int result = 0; TAI_KHOAN k = context.TAI_KHOAN.FirstOrDefault(m => m.MA_TK == p.MA_TK); if (k != null) { k.USERNAME = p.USERNAME; k.PASSWORD = p.PASSWORD; k.TRANG_THAI = p.TRANG_THAI; } result = context.SaveChanges(); return(result); }
private void btn_luu_Click(object sender, EventArgs e) { try { if (btn_sua.Enabled == false) //đang thêm { if (txt_matk.Text == string.Empty) { MessageBox.Show("Vui lòng nhập mã tài khoản"); txt_matk.Focus(); return; } TAI_KHOAN tk = new TAI_KHOAN(); tk.MATK = txt_matk.Text; tk.TENTK = txt_tentk.Text; tk.MALOAI = cbo_tiente.SelectedValue.ToString(); tk.MANGUOIDUNG = manguoidung; tk.SODUBD = (txt_sodubd.Text == null ? 0 : decimal.Parse(txt_sodubd.Text)); tk.SODUHT = tk.SODUBD; tk.TRANGTHAI = true; tk.DIENGIAI = txt_chuthich.Text; tk.MA_LOAI_TK = int.Parse(cbo_loaitk.SelectedValue.ToString()); int kq = qlq.Them_TK(tk); Load_DATA(); btn_luu.Enabled = false; btn_sua.Enabled = btn_xoa.Enabled = true; txt_matk.Enabled = txt_sodubd.Enabled = txt_soduht.Enabled = txt_tentk.Enabled = cbo_loaitk.Enabled = cbo_tiente.Enabled = txt_chuthich.Enabled = false; if (kq == 0) { MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Thêm thất bại"); } } if (btn_them.Enabled == false) //đang sửa { qlq.Sua_TK(txt_matk.Text, txt_tentk.Text, cbo_tiente.SelectedValue.ToString(), int.Parse(cbo_loaitk.SelectedValue.ToString()), decimal.Parse(txt_sodubd.Text), txt_chuthich.Text); txt_matk.Enabled = txt_sodubd.Enabled = txt_soduht.Enabled = txt_tentk.Enabled = cbo_loaitk.Enabled = cbo_tiente.Enabled = txt_chuthich.Enabled = btn_luu.Enabled = false; btn_xoa.Enabled = btn_them.Enabled = true; Load_DATA(); MessageBox.Show("Sửa thành công"); } } catch (Exception ex) { } }
// cập nhật tài khoản public int Sua_TK(string ma, string ten, string maloai, int maloaitk, decimal sodubd, string chuthich) { TAI_KHOAN tk = qlq.TAI_KHOANs.Where(t => t.MATK == ma).FirstOrDefault(); tk.MATK = ma; tk.TENTK = ten; tk.MALOAI = maloai; tk.MA_LOAI_TK = maloaitk; tk.SODUBD = sodubd; tk.SODUHT = sodubd + TienThu(ma) - TienChi(ma); tk.DIENGIAI = chuthich; qlq.SubmitChanges(); return(0); }
public override bool ValidateUser(string username, string password) { TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext(); var user = from u in dataContext.TAI_KHOANs where u.Username == username select u; if (user.Count() == 1) { TAI_KHOAN tk = user.Single(); if (tk.Password.Equals(CryptographicHelper.CreatePasswordHash(password, tk.Salt))) { return(true); } } return(false); }
public override MembershipUser GetUser(string username, bool userIsOnline) { TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext(); var user = from u in dataContext.TAI_KHOANs where u.Username == username select u; if (user.Count() == 1) { TAI_KHOAN tk = user.Single(); int userID = tk.MaTaiKhoan; string email = tk.Email; bool isLockedOut = false; return(new CustomMembershipUser(username, userID, email, isLockedOut)); } return(null); }
//xóa tài khoản public int Xoa_Tk(string ma) { TAI_KHOAN tk = qlq.TAI_KHOANs.Where(t => t.MATK == ma).FirstOrDefault(); if (KT_KhoaNgoai(ma) == 1) { return(1); } try { qlq.TAI_KHOANs.DeleteOnSubmit(tk); qlq.SubmitChanges(); return(0); } catch (Exception ex) { return(1); } }
public override string ResetPassword(string username, string answer) { string newPassword = ""; TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext(); var user = from u in dataContext.TAI_KHOANs where u.Username == username select u; if (user.Count() == 1) { //newPassword = CryptographicHelper.GenerateKey(); newPassword = Membership.GeneratePassword(10, 3); TAI_KHOAN tk = user.Single(); tk.Password = CryptographicHelper.CreatePasswordHash(newPassword, tk.Salt); dataContext.SubmitChanges(); } return(newPassword); }
private void Remove() { try { if (System.Windows.Forms.MessageBox.Show("Xác nhận xoá? ", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { TAI_KHOAN tk = data.TAI_KHOANs.Single(item => item.TaiKhoan == txt_username.Text); data.TAI_KHOANs.DeleteOnSubmit(tk); data.SubmitChanges(); } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { GetData(); } }
private void Update() { TAI_KHOAN tk = (data.TAI_KHOANs.Where(t => t.TaiKhoan == txt_username.Text).SingleOrDefault <TAI_KHOAN>()); try { tk.MatKhau = txt_password.Text; tk.MaLoai = int.Parse(cb_loai.SelectedValue.ToString()); data.SubmitChanges(); tb_thongbao.Text = "Chỉnh sửa thành công!"; } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message, "Lỗi"); } finally { GetData(); } }
public override bool ChangePassword(string username, string oldPassword, string newPassword) { TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext(); var user = from u in dataContext.TAI_KHOANs where u.Username == username select u; if (user.Count() == 1) { TAI_KHOAN tk = user.Single(); oldPassword = CryptographicHelper.CreatePasswordHash(oldPassword, tk.Salt); newPassword = CryptographicHelper.CreatePasswordHash(newPassword, tk.Salt); if (oldPassword == tk.Password && oldPassword != newPassword) { tk.Password = newPassword; dataContext.SubmitChanges(); return(true); } } return(false); }
//Trả về vai trò và mã nhân viên public override string[] GetRolesForUser(string username) { TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext(); var user = from u in dataContext.TAI_KHOANs where u.Username.Equals(username) select u; if (user.Count() == 1) { TAI_KHOAN tk = user.Single(); var loaitk = from l in dataContext.LOAI_TAI_KHOANs where l.MaLoaiTaiKhoan == tk.LoaiTaiKhoan select l; if (loaitk.Count() == 1) { LOAI_TAI_KHOAN ltk = loaitk.Single(); return(new string[] { ltk.TenLoaiTaiKhoan, tk.MaNhanVien.ToString() }); } } return(new string[] { "", "" }); }
private void datagrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { int rowindex = datagrid.SelectedIndex; if (rowindex == -1) { Clear(); } else { TAI_KHOAN tk = (TAI_KHOAN)datagrid.SelectedItem; txt_username.Text = tk.TaiKhoan; txt_password.Text = tk.MatKhau; cb_loai.SelectedValue = tk.MaLoai; } } catch (Exception ex) { throw; } }
protected void btn_dangnhap_Click(object sender, EventArgs e) { string username = txt_email.Text; string password = txt_password.Text; byte[] pass = Encoding.ASCII.GetBytes(password); if (taiKhoanService.Login(username, pass)) { //TAI_KHOAN //Session["user_id"] = TAI_KHOAN tk = taiKhoanService.GetByUsername(username); Session["MA_KH"] = tk.MA_KH; KHACH_HANG kh = khachHangService.GetDVByMa(tk.MA_KH); Session["TEN_KH"] = kh.TEN_KH; Session["EMAIL"] = kh.EMAIL; Session["PHONE"] = kh.PHONE; Response.Redirect("../../Default.aspx"); } else { Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Alert", "alert('Đăng nhập không thành công')", true); } }