protected void Page_Load(object sender, EventArgs e) { DataView dv = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); int cid = (int)dv.Table.Rows[0][0]; ClientID.Text = cid.ToString(); }
protected void Page_Load(object sender, EventArgs e) { TextBox1.Text = DateTime.Now.ToString(); MembershipUser ma = Membership.GetUser(); TextBox2.Text = ma.ProviderUserKey.ToString(); if (User.IsInRole("client")) { DataView dv2 = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); TextBox3.Text = (string)dv2.Table.Rows[0][0]; Client.Insert(); Response.Redirect("~/Client/ClientAccount"); } else if (User.IsInRole("admin")) { DataView dv2 = (DataView)EmpIdSelect.Select(DataSourceSelectArguments.Empty); TextBox3.Text = (string)dv2.Table.Rows[0][0]; Emp.Insert(); Response.Redirect("~/admin/admin.aspx"); } else if (User.IsInRole("ysa")) { Response.Redirect(""); } else if (User.IsInRole("yc")) { Response.Redirect(""); } else { Response.Redirect("default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { DataView dv = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); int cid = (int)dv.Table.Rows[0][0]; ClientID.Text = cid.ToString(); DataView dv2 = (DataView)VenueIdSelect.Select(DataSourceSelectArguments.Empty); int vid = (int)dv2.Table.Rows[0][0]; VenueId.Text = vid.ToString(); DataView dv3 = (DataView)EventsSelect.Select(DataSourceSelectArguments.Empty); et = (string)dv3.Table.Rows[0][6]; }
protected void Page_Load(object sender, EventArgs e) { DateTime now = DateTime.Now; TimeZoneInfo timezone = TimeZoneInfo.FindSystemTimeZoneById("Singapore Standard Time"); TextBox1.Text = TimeZoneInfo.ConvertTime(now, timezone).ToString(); MembershipUser ma = Membership.GetUser(); TextBox2.Text = ma.ProviderUserKey.ToString(); if (User.IsInRole("client")) { DataView dv2 = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); TextBox3.Text = Convert.ToString((int)dv2.Table.Rows[0][0]); Session["ClientID"] = Convert.ToString((int)dv2.Table.Rows[0][0]); Session["ClientName"] = (string)dv2.Table.Rows[0][1]; Client.Insert(); Response.Redirect("~/Client/ClientAccount.aspx"); } else if (User.IsInRole("admin")) { DataView dv2 = (DataView)EmpIdSelect.Select(DataSourceSelectArguments.Empty); TextBox3.Text = Convert.ToString((int)dv2.Table.Rows[0][0]); Session["EmployeeID"] = Convert.ToString((int)dv2.Table.Rows[0][0]); Session["EmployeeName"] = (string)dv2.Table.Rows[0][2]; Emp.Insert(); Response.Redirect("~/Admin/Admin.aspx"); } else if (User.IsInRole("ysa")) { Response.Redirect(""); } else if (User.IsInRole("yc")) { Response.Redirect(""); } else { Response.Redirect("default.aspx"); } }
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["ReservationId"] == null) { Response.Redirect("~/UnableAccess.aspx"); } string key; DataView dvb = (DataView)UserIdSelect.Select(DataSourceSelectArguments.Empty); try { uid = (string)dvb.Table.Rows[0][0]; } catch (Exception) { Response.Redirect("~/UnableAccess.aspx"); } MembershipUser ma = Membership.GetUser(); key = ma.ProviderUserKey.ToString(); if (uid == key) { } else { Response.Redirect("~/UnableAccess.aspx"); } DataView dv = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); int cid = (int)dv.Table.Rows[0][0]; ClientID.Text = cid.ToString(); tagg = (int)dv.Table.Rows[0][1]; if (tagg == 1) { Button1.Visible = false; rc1.Visible = false; rs1.Visible = false; Billing2hide.Visible = false; balanceHide.Visible = false; } else if (tagg == 2) { rc2.Visible = false; rs2.Visible = false; Billing2hide.Visible = false; balanceHide.Visible = false; } else if (tagg == 3) { Button1.Text = "View Billing Statement"; Button5.Visible = false; rc2.Visible = false; rs2.Visible = false; Billing2hide.Visible = false; balanceHide.Visible = false; } else if (tagg == 4) { Button1.Text = "View Billing Statement"; Button5.Visible = false; rc2.Visible = false; rs2.Visible = false; rc1.Visible = false; rs1.Visible = false; Billing2hide.Visible = false; balanceHide.Visible = true; } else if (tagg == 5) { tag5Hide.Visible = false; Billing2hide.Visible = false; } else if (tagg == 6) { balanceHide.Visible = true; tag5Hide.Visible = false; Billing2hide.Visible = true; } LinkButton1.Attributes.Add("onclick", "window.open('../2ndBill.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["ReservationId"] == null) { Response.Redirect("~/UnableAccess.aspx"); } string key; DataView dvb = (DataView)UserIdSelect.Select(DataSourceSelectArguments.Empty); try { uid = (string)dvb.Table.Rows[0][0]; } catch (Exception) { Response.Redirect("~/UnableAccess.aspx"); } MembershipUser ma = Membership.GetUser(); key = ma.ProviderUserKey.ToString(); if (uid == key) { } else { Response.Redirect("~/UnableAccess.aspx"); } DataView dv = (DataView)ClientIdSelect.Select(DataSourceSelectArguments.Empty); int cid = (int)dv.Table.Rows[0][0]; ClientID.Text = cid.ToString(); tagg = (int)dv.Table.Rows[0][1]; if (tagg == 1) { Button1.Visible = false; rc1.Visible = false; } else if (tagg == 2) { rc2.Visible = false;; } else if (tagg == 3) { Button1.Text = "View Billing Statement"; Button5.Visible = false; rc2.Visible = false; } else if (tagg == 4) { Button1.Text = "View Billing Statement"; Button5.Visible = false; rc2.Visible = false; rc1.Visible = false; balanceHide.Visible = true; } else if (tagg == 5) { tag5Hide.Visible = false; } else if (tagg == 6) { balanceHide.Visible = true; tag5Hide.Visible = false; } }