public ActionResult Delete(int id)
{
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
ORDERS_DETAIL deleteOrderDetail = new ORDERS_DETAIL();
deleteOrderDetail = orderDetailService.GetOrderDetailsById(id);
return(View(deleteOrderDetail));
}
public ActionResult Edit(int id)
{
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
ORDERS_DETAIL editOrderDetail = new ORDERS_DETAIL();
editOrderDetail = orderDetailService.GetOrderDetailsById(id);
return(View(editOrderDetail));
}
// GET: OrderDetail
public ActionResult IndexOrdersDetail()
{
ViewBag.Title = "Detalle de ordenes";
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
var ordersDetailList = orderDetailService.GetAllOrdersDetails();
return(View(ordersDetailList));
}
public Datos()
{
InitializeComponent();
gridClientes.Columns.Add("nombre", "Nombre");
gridClientes.Columns.Add("telefono", "Telefono");
gridClientes.Columns.Add("state", "State");
gridProductos.Columns.Add("nombre", "Nombre");
gridProductos.Columns.Add("precio", "precio al costo");
gridProductos.Columns.Add("state", "State");
gridOrdenes.Columns.Add("fecha", "Fecha");
gridOrdenes.Columns.Add("total", "Total");
gridOrdenes.Columns.Add("state", "State");
gridDetOrd.Columns.Add("id_orden", "Id de orden");
gridDetOrd.Columns.Add("id_producto", "Id de producto");
gridDetOrd.Columns.Add("cantidad", "Cantidad");
gridDetOrd.Columns.Add("total", "Total");
customerService = new Order_Graber_DataService.Services.CustomerService();
var customersList = customerService.GetAllCustomers();
foreach (var i in customersList)
{
gridClientes.Rows.Add(i.customer_name, i.phone, i.state);
}
productService = new Order_Graber_DataService.Services.ProductService();
var products = productService.GetAllProducts();
foreach (var i in products)
{
gridProductos.Rows.Add(i.product_name, i.cost_price, i.state);
}
orderService = new Order_Graber_DataService.Services.OrderService();
var orderList = orderService.GetAllOrders();
foreach (var i in orderList)
{
gridOrdenes.Rows.Add(i.order_date, i.total_order, i.state);
}
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
var ordersDetails = orderDetailService.GetAllOrdersDetails();
foreach (var i in ordersDetails)
{
gridDetOrd.Rows.Add(i.order_id, i.product_id, i.quantity, i.total_line);
}
}
private void button7_Click(object sender, EventArgs e)
{
gridDetOrd.Rows.Clear();
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
var ordersDetails = orderDetailService.GetAllOrdersDetails();
foreach (var i in ordersDetails)
{
gridDetOrd.Rows.Add(i.order_id, i.product_id, i.quantity, i.total_line);
}
}
public ActionResult Delete(int id, ORDERS_DETAIL datosFront)
{
try
{
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
ORDERS_DETAIL deleteOrderDetail = new ORDERS_DETAIL()
{
order_id = id
};
orderDetailService.DeleteOrderDetail(deleteOrderDetail.line_id);
return(RedirectToAction("indexOrdersDetail"));
}
catch
{
return(View());
}
}
public ActionResult Create(ORDERS_DETAIL datosFront)
{
try
{
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
ORDERS_DETAIL newOrderDetail = new ORDERS_DETAIL()
{
order_id = datosFront.order_id,
product_id = datosFront.product_id,
quantity = datosFront.quantity,
total_line = datosFront.total_line,
ORDERS = datosFront.ORDERS,
PRODUCTS = datosFront.PRODUCTS,
};
orderDetailService.InsertOrderDetail(newOrderDetail);
return(RedirectToAction("IndexOrdersDetail"));
}
catch
{
return(View());
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
orderDetailService = new Order_Graber_DataService.Services.OrderDetailService();
ORDERS_DETAIL newOrderDetail = new ORDERS_DETAIL()
{
order_id = Decimal.ToInt32(numericUpDown1.Value),
product_id = Decimal.ToInt32(numericUpDown2.Value),
quantity = Decimal.ToInt32(numericUpDown3.Value),
total_line = Decimal.ToInt32(numericUpDown4.Value)
};
orderDetailService.InsertOrderDetail(newOrderDetail);
Datos Check = new Datos();
Check.Show();
Hide();
}
catch
{
MessageBox.Show("Error");
}
}
