protected void UpdatePanel1_Load(object sender, EventArgs e)
{
//Populate Orders grid
Order order = new Order();
DataTable dataTable = order.ToDataTable(order.GetAllOrders());
GridViewOrders.DataSource = dataTable;
GridViewOrders.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] == null)
Response.Redirect("~/Login.aspx");
else
{
Order ord = new Order();
HistoryGrid.DataSource = ord.ToDataTable(ord.GetAllOrdersByUserID(Convert.ToInt32(Session["UserID"])));
DataBind();
if (!Page.IsPostBack)
{
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Obtain Order ID from query string
int orderid = Convert.ToInt32(Request.QueryString["orderid"]);
//Get Order by its orderid
Order order = new Order();
order.GetOrderByID(orderid);
//Populate Delivery Types dropdown list
DeliveryType dt = new DeliveryType();
List<DeliveryType> dtypes = dt.GetAllDeliveryTypes();
DropDownListDeliveryType.DataSource = dtypes;
DropDownListDeliveryType.DataTextField = "Name";
DropDownListDeliveryType.DataValueField = "DeliveryTypeID";
DropDownListDeliveryType.DataBind();
//Populate Users dropdown list
User user = new User();
List<User> users = user.GetAllUsers();
DropDownListUsers.DataSource = users;
DropDownListUsers.DataTextField = "Username";
DropDownListUsers.DataValueField = "UserID";
DropDownListUsers.DataBind();
//Put order details into fields
LabelOrderID.Text = Request.QueryString["orderid"].ToString();
DropDownListUsers.SelectedValue = Convert.ToString(order.UserID);
TextBoxSubtotal.Text = Convert.ToString(order.Subtotal);
TextBoxTaxes.Text = Convert.ToString(order.Taxes);
TextBoxDeliveryCost.Text = Convert.ToString(order.DeliveryCost);
DropDownListDeliveryType.SelectedValue = Convert.ToString(order.DeliveryTypeID);
TextBoxGrandTotal.Text = Convert.ToString(order.GrandTotal);
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
try
{
//Create a Order object
Order order = new Order();
//Get existing order by its id
order.GetOrderByID(Convert.ToInt32(LabelOrderID.Text));
//Update all fields
order.UserID = Convert.ToInt32(DropDownListUsers.SelectedValue);
order.Subtotal = Convert.ToDouble(TextBoxSubtotal.Text);
order.Taxes = Convert.ToDouble(TextBoxTaxes.Text);
order.DeliveryCost = Convert.ToDouble(TextBoxDeliveryCost.Text);
order.DeliveryTypeID = Convert.ToInt32(DropDownListDeliveryType.SelectedValue);
order.GrandTotal = Convert.ToDouble(TextBoxGrandTotal.Text);
order.Modified = DateTime.Now;
//Update the order
if (order.UpdateOrder())
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "window.top.window.$.fancybox.close();", true);
}
else
{
LabelOutput.ForeColor = System.Drawing.Color.Red;
LabelOutput.Text = "Error: Update Failed";
}
}
catch (Exception ex)
{
LabelOutput.ForeColor = System.Drawing.Color.Red;
LabelOutput.Text = "Error: " + ex.Message;
}
}
private void reloadGridView()
{
if (DropDownListDBTables.SelectedValue == "Administrators")
{
//Get all objects
Administrator obj = new Administrator();
List<Administrator> list = obj.GetAllAdministrators(false);
//Fill a rendered object list
List<RenderAdministrator> renderedList = new List<RenderAdministrator>();
foreach (Administrator x in list)
{
renderedList.Add(new RenderAdministrator(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Audits")
{
//Get all objects
Audit obj = new Audit();
List<Audit> list = obj.GetAllAudits();
//Fill a rendered object list
List<RenderAudit> renderedList = new List<RenderAudit>();
foreach (Audit x in list)
{
renderedList.Add(new RenderAudit(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "AuditTypes")
{
//Get all objects
AuditType obj = new AuditType();
List<AuditType> list = obj.GetAllAuditTypes();
//Fill a rendered object list
List<RenderAuditType> renderedList = new List<RenderAuditType>();
foreach (AuditType x in list)
{
renderedList.Add(new RenderAuditType(x));
}
GridViewDBTable.DataSource = renderedList;
}
if (DropDownListDBTables.SelectedValue == "Categories")
{
//Get all objects
Category obj = new Category();
List<Category> list = obj.GetAllCategories(false);
//Fill a rendered object list
List<RenderCategory> renderedList = new List<RenderCategory>();
foreach (Category x in list)
{
renderedList.Add(new RenderCategory(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Configurations")
{
//Get all objects
Configuration obj = new Configuration();
List<Configuration> list = obj.GetAllConfigurations();
//Fill a rendered object list
List<RenderConfiguration> renderedList = new List<RenderConfiguration>();
foreach (Configuration x in list)
{
renderedList.Add(new RenderConfiguration(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "DeliveryType")
{
//Get all objects
DeliveryType obj = new DeliveryType();
List<DeliveryType> list = obj.GetAllDeliveryTypes();
//Fill a rendered object list
List<RenderDeliveryType> renderedList = new List<RenderDeliveryType>();
foreach (DeliveryType x in list)
{
renderedList.Add(new RenderDeliveryType(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "LangLabels")
{
//Get all objects
LangLabel obj = new LangLabel();
List<LangLabel> list = obj.GetAllLangLabels();
//Fill a rendered object list
List<RenderLangLabel> renderedList = new List<RenderLangLabel>();
foreach (LangLabel x in list)
{
renderedList.Add(new RenderLangLabel(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "OrderItems")
{
//Get all objects
OrderItem obj = new OrderItem();
List<OrderItem> list = obj.GetAllOrderItems();
//Fill a rendered object list
List<RenderOrderItem> renderedList = new List<RenderOrderItem>();
foreach (OrderItem x in list)
{
renderedList.Add(new RenderOrderItem(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Orders")
{
//Get all objects
Order obj = new Order();
List<Order> list = obj.GetAllOrders();
//Fill a rendered object list
List<RenderOrder> renderedList = new List<RenderOrder>();
foreach (Order x in list)
{
renderedList.Add(new RenderOrder(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "ProductDeliveryTypes")
{
//Get all objects
ProductDeliveryType obj = new ProductDeliveryType();
List<ProductDeliveryType> list = obj.GetAllProductDeliveryTypes();
//Fill a rendered object list
List<RenderProductDeliveryType> renderedList = new List<RenderProductDeliveryType>();
foreach (ProductDeliveryType x in list)
{
renderedList.Add(new RenderProductDeliveryType(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Products")
{
//Get all objects
Product obj = new Product();
List<Product> list = obj.GetAllProducts(false);
//Fill a rendered object list
List<RenderProduct> renderedList = new List<RenderProduct>();
foreach(Product x in list)
{
renderedList.Add(new RenderProduct(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "StatesProvinces")
{
//Get all objects
StateProvince obj = new StateProvince();
List<StateProvince> list = obj.GetAllStatesProvinces();
//Fill a rendered object list
List<RenderStateProvince> renderedList = new List<RenderStateProvince>();
foreach (StateProvince x in list)
{
renderedList.Add(new RenderStateProvince(x));
}
GridViewDBTable.DataSource = renderedList;
}
else if (DropDownListDBTables.SelectedValue == "Users")
{
//Get all objects
User obj = new User();
List<User> list = obj.GetAllUsers();
//Fill a rendered object list
List<RenderUser> renderedList = new List<RenderUser>();
foreach (User x in list)
{
renderedList.Add(new RenderUser(x));
}
GridViewDBTable.DataSource = renderedList;
}
//Databind the new datasource obtained above
GridViewDBTable.DataBind();
}
