protected void ButtonDoi_Click(object sender, EventArgs e)
{
String sql = string.Format("Select * from NguoiDung where TaiKhoan ='{0}'", Session["ten"]);
DataTable table = DungChung.XemQuery(sql);
string sqlmatkhau;
String matkhaucu = table.Rows[0]["matkhau"].ToString();
if (TextBoxCu.Text != null && TextBoxMoi.Text != null && TextBoxNhapLai.Text != null)
{
if (TextBoxCu.Text == matkhaucu)
{
if (TextBoxMoi.Text == TextBoxNhapLai.Text)
{
sqlmatkhau = String.Format("Update NguoiDung Set MatKhau = '{0}' where TaiKhoan = '{1}'", TextBoxMoi.Text, Session["ten"].ToString());
DungChung.ThemSuaXoaQuery(sqlmatkhau);
LabelBaoLoi.Visible = false;
Response.Write("<script>alert('Đổi thành công')</script>");
}
else
{
LabelBaoLoi.Text = "Mật khẩu mới và nhập lại mật khẩu không khớp";
}
}
else
{
LabelBaoLoi.Text = "Mật khẩu cũ không đúng";
}
}
}
protected void ButtonDoi_Click(object sender, EventArgs e)
{
String sql = String.Format("Update NguoiDung set TenNguoiDung = '{0}', Email = '{1}', DiaChi = '{2}' Where TaiKhoan = '{3}'", TextBoxTen.Text, TextBoxEmail.Text, TextBoxDiaChi.Text, Session["ten"].ToString());
DungChung.ThemSuaXoaQuery(sql);
Response.Write("<script>alert('Đổi thành công')</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (System.Web.HttpContext.Current.Session["ten"] == null)
{
Response.Redirect("DangNhap.aspx");
}
String sql = String.Format("Select * from NguoiDung where TaiKhoan ='{0}'", Session["ten"].ToString());
DataTable tbl = DungChung.XemQuery(sql);
TextBoxTen.Text = tbl.Rows[0]["TenNguoiDung"].ToString();
TextBoxEmail.Text = tbl.Rows[0]["Email"].ToString();
TextBoxDiaChi.Text = tbl.Rows[0]["DiaChi"].ToString();
}
}
protected void ButtonDangNhap_Click(object sender, EventArgs e)
{
String sql = String.Format("Select * from NguoiDung where TaiKhoan = '{0}' and MatKhau = '{1}'", TXTTenDangNhap.Text, TXTPassword.Text);
DataTable tbl = DungChung.XemQuery(sql);
if (tbl.Rows.Count > 0)
{
Session["Ten"] = TXTTenDangNhap.Text;
Response.Redirect("TrangChu.aspx");
}
else
{
LabelStatus.Text = "Sai tài khoản hoặc mật khẩu!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["sql"]))
{
String sql = Request.QueryString["sql"].ToString();
DataTable tbl = DungChung.XemQuery(sql);
GridViewHoaDon.DataSource = tbl;
GridViewHoaDon.DataBind();
//xuat docx
Response.ClearContent();
Response.AppendHeader("content-disposition", "attachment; filename=Khach_Hang.doc");
Response.ContentType = "application/word";
StringWriter stringWriter = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(stringWriter);
GridViewHoaDon.RenderControl(htw);
Response.Write(stringWriter.ToString());
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (System.Web.HttpContext.Current.Session["ten"] == null)
{
Response.Redirect("DangNhap.aspx");
}
String sql = "Select * from KhachHang";
table = DungChung.XemQuery(sql);
GridViewKhachHang.DataSource = table;
GridViewKhachHang.DataBind();
String doublequote = "\"'',''\"";
String sqlincome = @"SELECT Sum(HoaDon.TongSoTien) AS SumOfTongSoTien, Format([NgayDi],'mm" + doublequote + @"yyyy') AS thoigian
FROM DatPhong INNER JOIN HoaDon ON DatPhong.ID = HoaDon.IDDatPhong
GROUP BY Format([NgayDi],'mm" + doublequote + @"yyyy');";
DataTable tableincome = DungChung.XemQuery(sqlincome);
Chart1.DataSource = tableincome;
Chart1.DataBind();
}
