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;
}
