public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Quantity,UnitaryPrice,TotalPrice,OrderId,InstrumentId")] LineOrder lineOrder)
{
if (id != lineOrder.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(lineOrder);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LineOrderExists(lineOrder.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["InstrumentId"] = new SelectList(_context.Instrument, "Id", "Brand", lineOrder.InstrumentId);
ViewData["OrderId"] = new SelectList(_context.Order, "Id", "State", lineOrder.OrderId);
return(View(lineOrder));
}
public ActionResult quantityBy1(int?id, int operation)
{
ISession session = _signInManager.Context.Session;
Order cartOrder = retrieveCart(session);
Instrument instrument = _context.Instrument.Find(id);
//LineOrder lineOr = GetLineOrder((int)id,cartOrder); //lineOr NULL
LineOrder lineOr = _context.LineOrder.Find(id);
if (operation < 0)
{
lineOr.Quantity--;
}
else
{
lineOr.Quantity++;
}
_context.LineOrder.Update(lineOr);
_context.SaveChanges();
int nLineOrders = countCartLines(session);
if (nLineOrders == -1)
{
return(StatusCode(400));
}
else
{
updateOrder(nLineOrders);//$ FULL-SPAGUETTI
return(StatusCode(200, nLineOrders));
}
}
public ActionResult deleteLine(int?id)
{
if (id == null)
{
return(StatusCode(400)); //bad request
}
LineOrder linea = _context.LineOrder.Find(id);
if (linea == null)
{
return(StatusCode(404)); //not found
}
//return View(linea);
//tmp until SureDelete View Created:
_context.LineOrder.Remove(linea);
_context.SaveChanges();
ISession session = _signInManager.Context.Session;
int nLineOrders = countCartLines(session);
//return RedirectToAction("Index","Cart");
if (nLineOrders == -1)
{
return(StatusCode(400));
}
else
{
updateOrder(nLineOrders);//$ FULL-SPAGUETTI
return(StatusCode(200, nLineOrders));
//return RedirectToAction("Index","Cart");
}
}
public ActionResult deleteLinePost(int?id)
{
LineOrder linea = _context.LineOrder.Find(id);
_context.LineOrder.Remove(linea);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create([Bind("Id,Name,Quantity,UnitaryPrice,TotalPrice,OrderId,InstrumentId")] LineOrder lineOrder)
{
if (ModelState.IsValid)
{
_context.Add(lineOrder);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["InstrumentId"] = new SelectList(_context.Instrument, "Id", "Brand", lineOrder.InstrumentId);
ViewData["OrderId"] = new SelectList(_context.Order, "Id", "State", lineOrder.OrderId);
return(View(lineOrder));
}
public void insertAttribsIds(string attribsValues, LineOrder line) //attribsValues input "Rojo,Madera,Set Puas"
{
//attribsValues to AttribsId comma separated
string attribsIds = "";
string[] attsValues = attribsValues.Split(',');
foreach (var value in attsValues)
{
string attId = _context.Attribut.Where(a => a.Value == value).FirstOrDefault().Id.ToString();
attribsIds += attId + ",";
}
attribsIds = attribsIds.Remove(attribsIds.Length - 1); //deleting last ','
//set line.Attribs = attribsId
line.AtributsId = attribsIds; //Attributes Id's comma separated for lineOrder
}
/// <summary>
/// Método para insertar una orden a la base de datos
/// </summary>
/// <param name="lineOrderToAdd"></param>
/// <returns> confirma la insercción con un boolean</returns>
public Boolean insertLineOrder(LineOrder lineOrderToAdd)
{
string query = "CALL InsertarLineaOrden(@P0,@P1,@P2)";
MySqlConnection conection = new MySqlConnection(connectionString);
using (MySqlCommand command = new MySqlCommand(query, conection))
{
command.Parameters.AddWithValue("@P0", lineOrderToAdd.quantity);
command.Parameters.AddWithValue("@P1", lineOrderToAdd.orderId);
command.Parameters.AddWithValue("@P2", lineOrderToAdd.productId);
conection.Open();
command.ExecuteNonQuery();
conection.Close();
return(true);
}
}
/// <summary>
/// El evento que inserta la orden a la base de datos y tambien cada línea de orden de la factura
/// </summary>
/// <returns>Retorna un boolean con la confirmación de que se agregó</returns>
public Boolean addOrderAndLineOrders()
{
if (validationForm() == true)
{
if (GridView1.Rows.Count == 0)
{
StringBuilder sbMensaje = new StringBuilder();
sbMensaje.Append("<script type='text/javascript'>");
sbMensaje.AppendFormat("toastr.warning('Debe insertar productos a la orden para enviarla');");
sbMensaje.Append("</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "mensaje", sbMensaje.ToString());
}
else
{
orderList = order.lastOrder();
int nextOrder = orderList + 1;
Order orderObject = new Order();
orderObject.orderID = nextOrder;
orderObject.partyId = Convert.ToInt32(Session["ID"]);
orderObject.orderType = (Char)Session["TypeOrder"];
orderObject.estadeId = 1;
if (txtClientName.Text.Trim() == "")
{
orderObject.nameClient = "Desconocido";
}
else
{
orderObject.nameClient = txtClientName.Text.Trim();
}
if (Session["TypeOrder"].Equals('2'))
{
orderObject.address = tbDirection.Text.Trim();
orderObject.phone = Convert.ToInt32(tbPhone.Text.Trim());
}
else
{
if (Session["TypeOrder"].Equals('1'))
{
orderObject.tableNumber = txtNumTable.Text.Trim();
orderObject.phone = 0;
orderObject.address = "";
}
}
orderObject.additional = txtDescription.Text.Trim();
order.insertOrder(orderObject);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
LineOrder lineOrder = new LineOrder();
lineOrder.orderId = nextOrder;
lineOrder.productId = Convert.ToInt32(GridView1.Rows[i].Cells[1].Text.Trim());
lineOrder.quantity = System.Convert.ToInt32(((TextBox)this.GridView1.Rows[i].Cells[4].FindControl("TextBox1")).Text.Trim());
order.insertLineOders(lineOrder);
}
return(true);
}
}
return(false);
}
public ActionResult addToCart(int id, string attribsValues = null)
{
ISession session = _signInManager.Context.Session;
//OPTIMIZA Y TESTEA ESTA SHIT DE CODIGO !!
Order cartOrder = retrieveCart(session);
// if(session.GetInt32("cartId") == null)
// {
// cartOrder = retrieveCart(session);
// }
Instrument instrument = _context.Instrument.Find(id);
LineOrder lineOr = GetLineOrder(id, cartOrder); //lineOr NULL
try
{
if (lineOr != null && instrument == lineOr.Instrument) //lineOr.Instrument NULL
{
lineOr.Quantity++;
//UPDATE LINE ORDER ON DB
_context.LineOrder.Update(lineOr);
_context.SaveChanges();
}
else
{
lineOr = new LineOrder {
Order = cartOrder,
OrderId = (int)session.GetInt32("cartId"),
Instrument = instrument,
InstrumentId = instrument.Id,
Name = instrument.Name,
Quantity = 1,
UnitaryPrice = instrument.Price,
TotalPrice = instrument.Price
};
//Adding attribs to LineOrder
if (String.IsNullOrEmpty(attribsValues)) //Attribs passed
{ //Default Attribs
attribsValues = getDefValuesEachType(lineOr.InstrumentId);
}
insertAttribsIds(attribsValues, lineOr);
_context.LineOrder.Add(lineOr);
_context.SaveChanges();
}
}
catch (System.Exception) { throw; }
int nLineOrders = countCartLines(session);
//return RedirectToAction("Index","Cart");
if (nLineOrders == -1)
{
return(StatusCode(400));
}
else
{
updateOrder(nLineOrders);//$ FULL-SPAGUETTI
return(StatusCode(200, nLineOrders));
}
}
/// <summary>
/// Call to insertOrder in the Data
/// </summary>
/// <param name="lineOrderToAdd"> Object</param>
/// <returns> Boolean </returns>
public bool insertLineOders(LineOrder lineOrderToAdd)
{
return(orderInData.insertLineOrder(lineOrderToAdd));
}
