// Subroutine to bind gridview
private void _subBind()
{
ordersClass objOrders = new ordersClass();
grv_orders.DataSource = objOrders.getOrders();
grv_orders.DataBind();
}
// Delete selected orders row
protected void DeleteOrders(object sender, EventArgs e)
{
LinkButton lnkDelete = (LinkButton)sender;
ordersClass objOrders = new ordersClass();
objOrders.OrdersID = Int32.Parse(lnkDelete.CommandArgument);
lbl_msg.Text = objOrders.deleteOrders();
_subBind();
}
// Insert new order
protected void InsertOrders(object sender, EventArgs e)
{
ordersClass objOrders = new ordersClass();
objOrders.OrdersName = txt_nameI.Text.ToString();
objOrders.OrdersNumber = txt_numberI.Text.ToString();
objOrders.OrdersFood = txt_foodI.Text.ToString();
objOrders.OrdersFoodquantity = Int32.Parse(txt_foodquantityI.Text.ToString());
objOrders.OrdersDrink = txt_drinkI.Text.ToString();
objOrders.OrdersDrinkquantity = Int32.Parse(txt_drinkquantityI.Text.ToString());
objOrders.OrdersSauce = Int32.Parse(txt_sauceI.Text.ToString());
objOrders.OrdersAddress = txt_addressI.Text.ToString();
lbl_msg.Text = objOrders.insertOrders();
_subBind();
}
// Update orders: updates the selected orders row
protected void UpdateOrders(object sender, GridViewUpdateEventArgs e)
{
ordersClass objOrders = new ordersClass();
objOrders.OrdersID = Int32.Parse(((Label)grv_orders.Rows[e.RowIndex].FindControl("lbl_ID")).Text);
objOrders.OrdersName = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_nameU")).Text;
objOrders.OrdersNumber = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_numberU")).Text;
objOrders.OrdersFood = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_foodU")).Text;
objOrders.OrdersFoodquantity = Int32.Parse(((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_foodquantityU")).Text);
objOrders.OrdersDrink = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_drinkU")).Text;
objOrders.OrdersDrinkquantity = Int32.Parse(((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_drinkquantityU")).Text);
objOrders.OrdersSauce = Int32.Parse(((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_sauceU")).Text);
objOrders.OrdersAddress = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_addressU")).Text;
lbl_msg.Text = objOrders.updateOrders();
grv_orders.EditIndex = -1;
_subBind();
}
//connected model
// Retrieves values from database table and passes values into properties. Stores values in a list and returns
public List <ordersClass> getOrders()
{
List <ordersClass> allOrders = new List <ordersClass>();
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM orders", conn);
try
{
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
// dr.read reads each row until there are none left
while (dr.Read())
{
ordersClass objOrders = new ordersClass();
objOrders.OrdersID = Convert.ToInt32(dr["id"].ToString());
objOrders.OrdersName = (string)dr["name"];
objOrders.OrdersNumber = (string)dr["number"];
objOrders.OrdersFood = (string)dr["food"];
objOrders.OrdersFoodquantity = Convert.ToInt32(dr["foodquantity"].ToString());
objOrders.OrdersDrink = (string)dr["drink"];
objOrders.OrdersDrinkquantity = Convert.ToInt32(dr["drinkquantity"].ToString());
objOrders.OrdersSauce = Convert.ToInt32(dr["sauce"].ToString());
objOrders.OrdersAddress = (string)dr["address"];
allOrders.Add(objOrders);
}
return(allOrders);
}
catch (Exception err)
{
allOrders.Clear();
ordersClass objOrders = new ordersClass();
objOrders.OrdersName = "Server Error (DB): " + err.Message.ToString();
allOrders.Add(objOrders);
return(allOrders);
}
finally
{
conn.Close();
}
}
