protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["ReservationId"] == null) { Response.Redirect("~/UnableAccess.aspx"); } DataView dvxxx = (DataView)Validates.Select(DataSourceSelectArguments.Empty); if ((int)dvxxx.Table.Rows[0][0] != 1) { Response.Redirect("~/UnableAccess.aspx"); } DataView dv = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); int cid = (int)dv.Table.Rows[0][0]; ClientID.Text = cid.ToString(); int tagg = (int)dv.Table.Rows[0][1]; Label8.Text = "Note: Once you Confirm your Bill it is subjected to create a Contract. You are not allowed to change your amenities and facilities reservation."; if (tagg >= 3) { Button1.Visible = false; Button2.Visible = false; Label8.Visible = false; } DataView dv1 = (DataView)ExpensesSelect.Select(DataSourceSelectArguments.Empty); if (dv1.Table.Rows[0][0] is DBNull) { oe = 0; } else { oe = (Double)dv1.Table.Rows[0][0]; } if (dv1.Table.Rows[0][1] is DBNull) { pb = 0; } else { pb = (Double)dv1.Table.Rows[0][1]; } vr = (Double)dv1.Table.Rows[0][2]; Label1.Text = vr.ToString("n2"); Label5.Text = oe.ToString("n2"); Label6.Text = pb.ToString("n2"); DataView dv2 = (DataView)Amenity.Select(DataSourceSelectArguments.Empty); DataView dv3 = (DataView)Facility.Select(DataSourceSelectArguments.Empty); DataView dv4 = (DataView)Misc.Select(DataSourceSelectArguments.Empty); if (dv2.Table.Rows[0][0] is DBNull) { amntyex = 0; } else { amntyex = (Double)dv2.Table.Rows[0][0]; } if (dv3.Table.Rows[0][0] is DBNull) { facex = 0; } else { facex = (Double)dv3.Table.Rows[0][0]; } if (dv4.Table.Rows[0][0] is DBNull) { miscex = 0; } else { miscex = (Double)dv4.Table.Rows[0][0]; } Label2.Text = amntyex.ToString("n2"); Label3.Text = facex.ToString("n2"); Label4.Text = miscex.ToString("n2"); total = oe + pb + vr + amntyex + facex + miscex; Label7.Text = total.ToString("n2"); LinkButton1.Attributes.Add("onclick", "window.open('../bill.aspx?ReservationId=" + Request.QueryString["ReservationId"] + "', 'newwindow','menubar=1,resizable=1,width=700,height=900');return false;"); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["newId"] == null) { Response.Redirect("~/UnableAccess.aspx"); } DataView dvxxx = (DataView)Validates.Select(DataSourceSelectArguments.Empty); if ((int)dvxxx.Table.Rows[0][0] != 1) { Response.Redirect("~/UnableAccess.aspx"); } Double oa = 0; Double pb = 0; DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); Label1.Text = (string)dv1.Table.Rows[0][1]; Label2.Text = (string)dv1.Table.Rows[0][2]; DateTime rdate = (DateTime)dv1.Table.Rows[0][6]; Label3.Text = rdate.ToString("MM/dd/yyyy"); Double era = (Double)dv1.Table.Rows[0][4]; if (dv1.Table.Rows[0][5] is DBNull) { Label6.Text = ""; Label7.Text = ""; } else { pb = (Double)dv1.Table.Rows[0][5]; Label6.Text = "Performance Bond"; Label7.Text = pb.ToString("n2"); } if (dv1.Table.Rows[0][3] is DBNull) { } else { oa = (Double)dv1.Table.Rows[0][3]; Label5.Text = oa.ToString("n2"); } Label4.Text = era.ToString("n2"); era = oa + era + pb; Label8.Text = era.ToString("n2"); if (dv1.Table.Rows[0][7] is DBNull) { Label9.Text = "No Reservation Fee."; } else { Double rf = (Double)dv1.Table.Rows[0][7]; Label9.Text = rf.ToString("n2"); } int vid = (int)dv1.Table.Rows[0][8]; TextBox4.Text = vid.ToString(); TextBox8.Text = Request.QueryString["newId"]; DataView dvy = (DataView)SqlDataSource8.Select(DataSourceSelectArguments.Empty); if ((int)dvy.Table.Rows[0][0] >= 1) { DataView dvx = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty); Double tl = (Double)dvx.Table.Rows[0][0]; Label10.Text = tl.ToString("n2"); } else { Label10.Text = "0"; } DataView dva = (DataView)rsvamntyCount.Select(DataSourceSelectArguments.Empty); if ((int)dva.Table.Rows[0][0] >= 1) { DataView dvb = (DataView)rsvamntySum.Select(DataSourceSelectArguments.Empty); Double tl2 = (Double)dvb.Table.Rows[0][0]; Label12.Text = tl2.ToString("n2"); } else { Label12.Text = "0"; } DataView dvz = (DataView)rsvmiscCount.Select(DataSourceSelectArguments.Empty); if ((int)dvz.Table.Rows[0][0] >= 1) { DataView dvw = (DataView)rsvmiscSum.Select(DataSourceSelectArguments.Empty); Double tl3 = (Double)dvw.Table.Rows[0][0]; Label13.Text = tl3.ToString("n2"); } else { Label13.Text = "0"; } Label11.Text = ""; TextBox3.ReadOnly = true; Double gtotal = Convert.ToDouble(Label8.Text) + Convert.ToDouble(Label10.Text) + Convert.ToDouble(Label12.Text) + Convert.ToDouble(Label13.Text); Label14.Text = gtotal.ToString("n2"); rsvupdatetotal.Update(); Button1.Enabled = false; Button2.Enabled = false; btn1.Enabled = false; btn2.Enabled = false; }