protected void btnReserv_Click(object sender, EventArgs e)
    {
        //lbBookingMess.Text = "Đặt bàn";
        int rs = 0;

        DatSpa data = new DatSpa();

        data.Ten = custumerName.Text;
        data.DiaChi = Address.Text;
        data.Email = String.Empty;
        data.SDT = Convert.ToInt32(Phone.Text.Trim());
        data.SoNguoi = Amount.Text;

        DateTime Ngay = DateTime.ParseExact(Date.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
        data.Ngay = Ngay;
        data.Gio = Hour.Text;

        data.NgayGui = DateTime.Now;
        data.TrangThai = 0;

        rs = DatSpa.Them(data);
        if (rs > 0)
        {
            refesh();
            lbBookingMess.Text = "Success, Thank you!";
        }
        else
        {
            lbBookingMess.Text = "Cannot book";
        }
    }
 protected void LoadDatSpa(DatSpa data)
 {
     //Thong tin khach hang
     lbID.Text = data.ID.ToString();
     lbdiachi.Text = data.DiaChi;
     lbhoten.Text = data.Ten;
     lbemail.Text = data.Email;
     lbgio.Text = data.Gio;
     lbnguoi.Text = data.SoNguoi;
     lbngaydat.Text = String.Format("{0:dd/MM/yyyy}", data.Ngay);
     lbsdt.Text = data.SDT.ToString();
     lbngaygui.Text = String.Format("{0:dd/MM/yyyy}", data.NgayGui);
     lbtrangthai.Text = LoaiStatus(data.TrangThai);
     titletrangthai.Text = data.TrangThai.ToString();
 }
示例#3
0
 public static int Them(DatSpa datspa)
 {
     try
     {
         object rs = DataProvider.Instance.ExecuteNonQueryWithOutput("@ID", "DatSpa_Them", datspa.ID, datspa.Ten, datspa.DiaChi, datspa.Email, datspa.SDT, datspa.SoNguoi, datspa.Ngay, datspa.Gio, datspa.TrangThai, datspa.NgayGui);
         return Convert.ToInt32(rs);
     }
     catch
     {
         return 0;
     }
 }
示例#4
0
 public static bool Sua(DatSpa datspa)
 {
     try
     {
         object rs = DataProvider.Instance.ExecuteNonQuery("DatSpa_Sua", datspa.ID, datspa.Ten, datspa.DiaChi, datspa.Email, datspa.SDT, datspa.SoNguoi, datspa.Ngay, datspa.Gio, datspa.TrangThai, datspa.NgayGui);
         return Convert.ToInt32(rs) > 0;
     }
     catch
     {
         return false;
     }
 }