public void SuaThongTin(QuanLyDTO ql) { String updateSQL = @"UPDATE NguoiDung SET HoTen = N'{0}', NgaySinh = '{1}', GioiTinh = '{2}', DiaChi = N'{3}', SDT = '{4}' WHERE MaNguoiDung = {5}"; String query = string.Format(updateSQL, ql.HoTen, ql.NgaySinh, ql.GioiTinh, ql.DiaChi, ql.SDT, ql.MaQuanLy); DataProvider.ExecuteQuery(query); }
public NguoiDungDTO KiemTraAccount(string username, string password) { NguoiDungDTO Kq = null; Connect(); SqlCommand cmd = new SqlCommand("spKiemTraAccount", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@username", SqlDbType.VarChar); cmd.Parameters.Add("@password", SqlDbType.VarChar); cmd.Parameters["@username"].Value = username; cmd.Parameters["@password"].Value = password; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { int loai = (int)dr["MaLoaiNguoiDung"]; switch (loai) { case 1: { Kq = new KhachHangDTO(); break; } case 2: { Kq = new NhanVienDTO(); break; } case 3: { Kq = new QuanLyDTO(); break; } default: { Kq = new QuanTriDTO(); break; } } Kq.Ma_nguoi_dung = (int)dr["MaNguoiDung"]; Kq.Ho_ten = dr["HoTen"].ToString(); Kq.Email = dr["Email"].ToString(); Kq.Username = dr["Username"].ToString(); Kq.Password = dr["Password"].ToString(); Kq.Tinh_trang_kich_hoat = (bool)dr["TinhTrangKichHoat"]; Kq.Ma_loai_nguoi_dung = (int)dr["MaLoaiNguoiDung"]; } Disconnect(); return(Kq); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lb_TenDangNhap.Text = Session["TenDangNhap"].ToString(); QuanLyBUS quanLyBUS = new QuanLyBUS(); QuanLyDTO quanLyDTO = quanLyBUS.LayThongTin(lb_TenDangNhap.Text); lb_ID.Text = quanLyDTO.MaQuanLy.ToString(); tb_HoTen.Text = quanLyDTO.HoTen; tb_NgaySinh.Text = quanLyDTO.NgaySinh; tb_GioiTinh.Text = (quanLyDTO.GioiTinh) ? "Nữ" : "Nam"; tb_DiaChi.Text = quanLyDTO.DiaChi; tb_SDT.Text = quanLyDTO.SDT; } }
public QuanLyDTO LayThongTin(string tendangnhap) { String query = string.Format("SELECT * FROM NguoiDung WHERE TenDangNhap = '{0}'", tendangnhap); DataTable dt = DataProvider.ExecuteQuery(query); QuanLyDTO quanLyDTO = new QuanLyDTO(); quanLyDTO.MaQuanLy = Convert.ToInt32(dt.Rows[0]["MaNguoiDung"]); quanLyDTO.HoTen = dt.Rows[0]["HoTen"].ToString(); quanLyDTO.NgaySinh = (dt.Rows[0]["NgaySinh"]).ToString(); quanLyDTO.GioiTinh = Convert.ToBoolean(dt.Rows[0]["GioiTinh"]); quanLyDTO.DiaChi = dt.Rows[0]["DiaChi"].ToString(); quanLyDTO.SDT = dt.Rows[0]["SDT"].ToString(); quanLyDTO.TenDangNhap = dt.Rows[0]["TenDangNhap"].ToString(); return(quanLyDTO); }
protected void btn_Sua_Click(object sender, EventArgs e) { QuanLyBUS quanLyBUS = new QuanLyBUS(); QuanLyDTO ql = new QuanLyDTO(); ql.MaQuanLy = Convert.ToInt32(lb_ID.Text); ql.HoTen = tb_HoTen.Text; ql.NgaySinh = tb_NgaySinh.Text; ql.GioiTinh = (tb_GioiTinh.Text == "Nữ"); ql.DiaChi = tb_DiaChi.Text; ql.SDT = tb_SDT.Text; quanLyBUS.SuaThongTin(ql); string strBuilder = "<script language='javascript'>alert('" + "Cập nhật thành công" + "')</script>"; Response.Write(strBuilder); }
public List <QuanLyDTO> LayDanhSach() { List <QuanLyDTO> listQuanLyDTO = new List <QuanLyDTO>(); String query = "SELECT * FROM QuanLy"; DataTable dt = DataProvider.ExecuteQuery(query); foreach (DataRow dr in dt.Rows) { QuanLyDTO quanLyDTO = new QuanLyDTO(); quanLyDTO.MaQuanLy = Convert.ToInt32(dr["MaNguoiDung"]); quanLyDTO.HoTen = dr["HoTen"].ToString(); quanLyDTO.NgaySinh = (dr["NgaySinh"]).ToString(); quanLyDTO.GioiTinh = Convert.ToBoolean(dr["GioiTinh"]); quanLyDTO.DiaChi = dr["DiaChi"].ToString(); quanLyDTO.SDT = dr["SDT"].ToString(); quanLyDTO.TenDangNhap = dr["TenDangNhap"].ToString(); listQuanLyDTO.Add(quanLyDTO); } return(listQuanLyDTO); }
public void SuaThongTin(QuanLyDTO ql) { quanLyDAO.SuaThongTin(ql); }
public void ThemQuanLy(QuanLyDTO ql) { quanLyDAO.ThemQuanLy(ql); }
public void ThemQuanLy(QuanLyDTO ql) { //String insertSQL = "INSERT INTO QuanLy VALUES ()"; //String query = string.Format(insertSQL ) //DataProvider.ExecuteQuery(query); }