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