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

        DatTiec data = new DatTiec();

        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 = DatTiec.Them(data);
        if (rs > 0)
        {
            refesh();
            lbBookingMess.Text = "Success, thank you!";
        }
        else
        {
            lbBookingMess.Text = "Cannot book";
        }
    }
示例#2
0
 protected void LoadDatTiec(DatTiec 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(DatTiec dattiec)
 {
     try
     {
         object rs = DataProvider.Instance.ExecuteNonQueryWithOutput("@ID", "DatTiec_Them", dattiec.ID, dattiec.Ten, dattiec.DiaChi, dattiec.Email, dattiec.SDT, dattiec.SoNguoi, dattiec.Ngay, dattiec.Gio, dattiec.TrangThai, dattiec.NgayGui);
         return Convert.ToInt32(rs);
     }
     catch
     {
         return 0;
     }
 }
示例#4
0
 public static bool Sua(DatTiec dattiec)
 {
     try
     {
         object rs = DataProvider.Instance.ExecuteNonQuery("DatTiec_Sua", dattiec.ID, dattiec.Ten, dattiec.DiaChi, dattiec.Email, dattiec.SDT, dattiec.SoNguoi, dattiec.Ngay, dattiec.Gio, dattiec.TrangThai, dattiec.NgayGui);
         return Convert.ToInt32(rs) > 0;
     }
     catch
     {
         return false;
     }
 }