private void button2_Click(object sender, EventArgs e)
{
try
{
productService = new Order_Graber_DataService.Services.ProductService();
PRODUCTS newProduct = new PRODUCTS()
{
product_code = textBox1.Text,
product_name = textBox2.Text,
cost_price = Decimal.ToDouble(numericUpDown1.Value),
sale_price = Decimal.ToDouble(numericUpDown2.Value),
state = textBox4.Text,
};
productService.InsertProduct(newProduct);
Datos Check = new Datos();
Check.Show();
Hide();
}
catch
{
MessageBox.Show("Error");
}
}
public ActionResult IndexProduct()
{
ViewBag.Title = "Productos";
productService = new Order_Graber_DataService.Services.ProductService();
return(View(productService.GetAllProducts()));
}
public ActionResult Edit(int id)
{
productService = new Order_Graber_DataService.Services.ProductService();
Order_Graber_DataService.PRODUCTS editProduct = new Order_Graber_DataService.PRODUCTS();
editProduct = productService.GetProductById(id);
return(View(editProduct));
}
public ActionResult Delete(int id)
{
productService = new Order_Graber_DataService.Services.ProductService();
Order_Graber_DataService.PRODUCTS deleteProduct = new Order_Graber_DataService.PRODUCTS();
deleteProduct = productService.GetProductById(id);
return(View(deleteProduct));
}
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 button3_Click(object sender, EventArgs e)
{
gridProductos.Rows.Clear();
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);
}
}
public ActionResult Delete(int id, PRODUCTS datosFront)
{
try
{
productService = new Order_Graber_DataService.Services.ProductService();
Order_Graber_DataService.PRODUCTS deleteProduct = new Order_Graber_DataService.PRODUCTS()
{
product_id = id,
};
productService.DeleteProduct(deleteProduct.product_id);
return(RedirectToAction("IndexProduct"));
}
catch
{
return(View());
}
}
public ActionResult Create(PRODUCTS datosFront)
{
try
{
productService = new Order_Graber_DataService.Services.ProductService();
Order_Graber_DataService.PRODUCTS newProduct = new Order_Graber_DataService.PRODUCTS()
{
product_code = datosFront.product_code,
product_name = datosFront.product_name,
cost_price = datosFront.cost_price,
sale_price = datosFront.sale_price,
state = datosFront.state
};
productService.InsertProduct(newProduct);
return(RedirectToAction("IndexProduct"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, Order_Graber_DataService.PRODUCTS datosFront)
{
try
{
productService = new Order_Graber_DataService.Services.ProductService();
Order_Graber_DataService.PRODUCTS updateProduct = new Order_Graber_DataService.PRODUCTS()
{
product_id = id,
product_code = datosFront.product_code,
product_name = datosFront.product_name,
cost_price = datosFront.cost_price,
sale_price = datosFront.sale_price,
state = datosFront.state,
};
productService.UpdateProduct(updateProduct);
return(RedirectToAction("IndexProduct"));
}
catch
{
return(View());
}
}
