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