protected void btnRegister_Click(object sender, EventArgs e)
{
try
{
Hashtable param = new Hashtable();
param.Add("@Phone", txtPhone.Text.Trim());
param.Add("@FirstName", txtFirstName.Text.Trim());
param.Add("@LastName", txtLastName.Text.Trim());
AdVantageData.RunProc(Properties.Settings.Default.AJVConnection, "usp_RWAddMember", param);
Response.Redirect("Confirmation.aspx?Store=2&Phone=" + txtPhone.Text);
}
catch (Exception exc)
{
lblMessage.Visible = true;
//lblMessage.Text = exc.Message + "/n" + exc.InnerException.Message;
lblMessage.Text = "Failed to add the new member...TRY AGAIN";
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblTime.Text = "Main 1 @ " + DateTime.UtcNow.AddHours(-8).ToShortDateString() + " " + DateTime.UtcNow.AddHours(-8).ToShortTimeString();
_conn = Properties.Settings.Default.MT1Connection;
DataTable dt = AdVantageData.GetDataTable(_conn, "usp_SummaryReport");
lblTotal.Text += Convert.ToInt32(dt.Rows[0]["Total"]).ToString();
lblSalesCount.Text += "(" + Convert.ToInt32(dt.Rows[0]["SalesCount"]).ToString() + ")";
lblCreditCard.Text += Convert.ToInt32(dt.Rows[0]["CreditCard"]).ToString();
lblCash.Text += Convert.ToInt32(dt.Rows[0]["Cash"]).ToString();
lblStoreCredit.Text += Convert.ToInt32(dt.Rows[0]["StoreCredit"]).ToString();
lblDiscount.Text += Convert.ToInt32(dt.Rows[0]["Discount"]).ToString();
lblReturn.Text += Convert.ToInt32(dt.Rows[0]["Return"]).ToString();
DataTable dt2 = AdVantageData.GetDataTable(_conn, "usp_HourlyReport");
dlHourly.DataSource = dt2;
dlHourly.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//TimeZoneInfo pacificZone = TimeZoneInfo.FindSystemTimeZoneById("P
lblTime.Text = "Main 2 @ " + DateTime.UtcNow.AddHours(-8).ToShortDateString() + " " + DateTime.UtcNow.AddHours(-8).ToShortTimeString();
_conn = Properties.Settings.Default.AJVConnection;
DataTable dt = AdVantageData.GetDataTable(_conn, "usp_SummaryReport");
lblTotal.Text += Convert.ToInt32(dt.Rows[0]["Total"]).ToString();
lblSalesCount.Text += "(" + Convert.ToInt32(dt.Rows[0]["SalesCount"]).ToString() + ")";
lblCreditCard.Text += Convert.ToInt32(dt.Rows[0]["CreditCard"]).ToString();
lblCash.Text += Convert.ToInt32(dt.Rows[0]["Cash"]).ToString();
if (Convert.ToInt32(dt.Rows[0]["StoreCredit"]) != 0)
{
imgStoreCredit.Visible = true;
lblStoreCredit.Text += Convert.ToInt32(dt.Rows[0]["StoreCredit"]).ToString();
}
else
{
imgStoreCredit.Visible = false;
lblStoreCredit.Visible = false;
}
if (Convert.ToInt32(dt.Rows[0]["Discount"]) != 0)
{
imgDiscount.Visible = true;
lblDiscount.Text += Convert.ToInt32(dt.Rows[0]["Discount"]).ToString();
}
else
{
imgDiscount.Visible = false;
lblDiscount.Visible = false;
}
if (Convert.ToInt32(dt.Rows[0]["Return"]) != 0)
{
lblReturn.Text += Convert.ToInt32(dt.Rows[0]["Return"]).ToString();
ImgReturn.Visible = true;
}
else
{
lblReturn.Visible = false;
ImgReturn.Visible = false;
}
DataTable dt2 = AdVantageData.GetDataTable(_conn, "usp_HourlyReport");
dlHourly.DataSource = dt2;
dlHourly.DataBind();
string customShirtsSQL = "select isnull(sum(Price),0) " +
" from transactionDetail where UPC='CATEGORY0015' and left(TransactionID,8)= replace(convert(varchar,getdate(),102),'.','')";
DataTable dt3 = AdVantageData.GetDataTableByScript(_conn, customShirtsSQL);
if (Convert.ToInt32(dt3.Rows[0][0]) != 0)
{
imgCustom.Visible = true;
lblCustom.Text = Convert.ToInt32(dt3.Rows[0][0]).ToString();
}
else
{
imgCustom.Visible = false;
lblCustom.Visible = false;
}
}
