protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("~/login.aspx");
}
server = (Server)Session["Employee"];
SQC = new sqlController();
DataTable dt = SQC.GetTotals(server);
if (dt != null)
{
if (dt.Rows[0]["Appetizer"].ToString() != "")
{
lblAppTotal.Text = String.Format("{0:C}", dt.Rows[0]["Appetizer"]);
}
if (dt.Rows[0]["Soup"].ToString() != "")
{
lblSoupTotal.Text = String.Format("{0:C}", dt.Rows[0]["Soup"]);
}
if (dt.Rows[0]["Beverage"].ToString() != "")
{
lblBeverageTotal.Text = String.Format("{0:C}", dt.Rows[0]["Beverage"]);
}
if (dt.Rows[0]["Sandwich"].ToString() != "")
{
lblSandwichTotal.Text = String.Format("{0:C}", dt.Rows[0]["Sandwich"]);
}
if (dt.Rows[0]["Salad"].ToString() != "")
{
lblSaladTotal.Text = String.Format("{0:C}", dt.Rows[0]["Salad"]);
}
if (dt.Rows[0]["Entree"].ToString() != "")
{
lblEntreeTotal.Text = String.Format("{0:C}", dt.Rows[0]["Entree"]);
}
if (dt.Rows[0]["Beer"].ToString() != "")
{
lblBeerTotal.Text = String.Format("{0:C}", dt.Rows[0]["Beer"]);
}
if (dt.Rows[0]["Wine"].ToString() != "")
{
lblWineTotal.Text = String.Format("{0:C}", dt.Rows[0]["Wine"]);
}
if (dt.Rows[0]["Dessert"].ToString() != "")
{
lblDessertTotal.Text = String.Format("{0:C}", dt.Rows[0]["Dessert"]);
}
lblSalesTotal.Text = String.Format("{0:C}", Sum(dt));
}
}
