protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ThongTinDKTour tt = new ThongTinDKTour();
String ma = maKH.Tang();
String maTour = Request.QueryString["maT"];
int soL = cn.Dem(maTour);
tt.MaKH = ma.ToString();
tt.MaTour = maTour.ToString();
tt.NgayDat = DateTime.Now;
tt.NguoiLon = int.Parse(lb_sl_nguoi_lon.Text);
tt.SoTreEm = int.Parse(sl_tre_em.Text);
tt.ThanhTien = float.Parse(lb_thanh_tien.Text);
int kq = cn.ThemTTDK(tt);
if (kq == 10)
{
cn.ThemTTDK(tt);
Response.Write("<script>alert('Thành công');</script>");
Response.Redirect("~/Content/ql_tour/Thongtinkhachhang.aspx?makh=" + ma.ToString());
}
else
{
Response.Write("<script>alert('Không thành công');</script>");
}
}
public int huy_ttdk(ThongTinDKTour tt, String ma)
{
try
{
tt = data.ThongTinDKTours.Where(t => t.MaKH == ma).FirstOrDefault();
if (tt != null)
{
KhachHang kh = data.KhachHangs.Where(t => t.MaKH == ma).FirstOrDefault();
if (kh != null)
{
huy_ttkh(kh, ma);
}
data.ThongTinDKTours.DeleteOnSubmit(tt);
data.SubmitChanges();
return(10);
}
else
{
return(11);
}
}
catch
{
return(0);
}
}
public int ThemTTDK(ThongTinDKTour tt)
{
try
{
data.ThongTinDKTours.InsertOnSubmit(tt);
data.SubmitChanges();
return(10);
}
catch
{
return(11);
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
ThongTinDKTour tt = new ThongTinDKTour();
string maKH = grid_ds_huy.DataKeys[e.RowIndex].Value.ToString();
int kq = cn.huy_ttdk(tt, maKH);
if (kq == 11 || kq == 0)
{
Response.Write("<script>alert('không có dữ liệu');</script>");
}
else
{
cn.huy_ttdk(tt, maKH);
Response.Write("<script>alert('Thành công');</script>");
//Response.Redirect("~/Content/ql_tour/Dattour.aspx?");
}
}
