public void SuaThongTin(KeToanDTO kt)
{
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, kt.HoTen, kt.NgaySinh, kt.GioiTinh, kt.DiaChi, kt.SDT, kt.MaKeToan);
DataProvider.ExecuteQuery(query);
}
protected void btn_Sua_Click(object sender, EventArgs e)
{
KeToanDTO keToanDTO = new KeToanDTO();
keToanDTO.MaKeToan = Convert.ToInt32(lb_ID.Text);
keToanDTO.HoTen = tb_HoTen.Text;
keToanDTO.NgaySinh = tb_NgaySinh.Text;
keToanDTO.GioiTinh = (tb_GioiTinh.Text == "Nữ");
keToanDTO.DiaChi = tb_DiaChi.Text;
keToanDTO.SDT = tb_SDT.Text;
KeToanBUS keToanBUS = new KeToanBUS();
keToanBUS.SuaThongTin(keToanDTO);
string strBuilder = "<script language='javascript'>alert('" + "Cập nhật thành công" + "')</script>";
Response.Write(strBuilder);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String tendangnhap = Session["TenDangNhap"].ToString();
KeToanBUS keToanBUS = new KeToanBUS();
KeToanDTO keToanDTO = keToanBUS.LayThongTin(tendangnhap);
lb_TenDangNhap.Text = tendangnhap;
lb_ID.Text = keToanDTO.MaKeToan.ToString();
tb_HoTen.Text = keToanDTO.HoTen;
tb_NgaySinh.Text = keToanDTO.NgaySinh;
//0 : Nam, 1 : Nữ
tb_GioiTinh.Text = (keToanDTO.GioiTinh) ? "Nữ" : "Nam";
tb_DiaChi.Text = keToanDTO.DiaChi;
tb_SDT.Text = keToanDTO.SDT;
}
}
public KeToanDTO LayThongTin(string tendangnhap)
{
KeToanDTO keToanDTO = null;
String query = string.Format("SELECT * FROM NguoiDung WHERE TenDangNhap = '{0}'", tendangnhap);
DataTable dt = DataProvider.ExecuteQuery(query);
if (dt.Rows.Count > 0)
{
keToanDTO = new KeToanDTO();
keToanDTO.MaKeToan = Convert.ToInt32(dt.Rows[0]["MaNguoiDung"]);
keToanDTO.HoTen = dt.Rows[0]["HoTen"].ToString();
keToanDTO.NgaySinh = (dt.Rows[0]["NgaySinh"]).ToString();
keToanDTO.GioiTinh = Convert.ToBoolean(dt.Rows[0]["GioiTinh"]);
keToanDTO.DiaChi = dt.Rows[0]["DiaChi"].ToString();
keToanDTO.SDT = dt.Rows[0]["SDT"].ToString();
keToanDTO.TenDangNhap = dt.Rows[0]["TenDangNhap"].ToString();
}
return(keToanDTO);
}
public List <KeToanDTO> LayDanhSach()
{
List <KeToanDTO> listKeToanDTO = new List <KeToanDTO>();
String query = "SELECT * FROM NguoiDung WHERE TenDangNhap = " +
"(SELECT TenDangNhap FROM TaiKhoan WHERE PhanQuyen = 'KT')";
DataTable dt = DataProvider.ExecuteQuery(query);
foreach (DataRow dr in dt.Rows)
{
KeToanDTO keToanDTO = new KeToanDTO();
keToanDTO.MaKeToan = Convert.ToInt32(dr["MaNguoiDung"]);
keToanDTO.HoTen = dr["HoTen"].ToString();
keToanDTO.NgaySinh = (dr["NgaySinh"]).ToString();
keToanDTO.GioiTinh = Convert.ToBoolean(dr["GioiTinh"]);
keToanDTO.DiaChi = dr["DiaChi"].ToString();
keToanDTO.SDT = dr["SDT"].ToString();
keToanDTO.TenDangNhap = dr["TenDangNhap"].ToString();
listKeToanDTO.Add(keToanDTO);
}
return(listKeToanDTO);
}
public void SuaThongTin(KeToanDTO kt)
{
keToanDAO.SuaThongTin(kt);
}
