private void button1_Click(object sender, EventArgs e)
{
try
{
DataAcces dataAcces = new DataAcces();
string tempID;
string description = productoTxt.Text;
int price = int.Parse(precioTxt.Text);
Product product = new Product(description, price);
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
tempID = row.Cells[0].Value.ToString();
product.Id = int.Parse(tempID);
}
dataAcces.UpdateProduct(product);
dataAcces.displayProducts(dataGridView1);
productoTxt.Clear();
precioTxt.Clear();
}
catch(Exception ex)
{
MessageBox.Show("Error "+ ex);
}
}
private void button1_Click(object sender, EventArgs e)
{
DataAcces dataAcces = new DataAcces();
try
{
string description = productoTxt.Text;
int price = int.Parse(precioTxt.Text);
string comment = comentarioTxt.Text;
Product product = new Product(description, price);
dataAcces.insertProduct(product);
productoTxt.Clear();
precioTxt.Clear();
comentarioTxt.Clear();
}
catch (Exception ex)
{
MessageBox.Show("Datos incorrectos! Favor revisar");
}
}
private void SaveOrderBTN_Click(object sender, EventArgs e)
{
DataAcces access = new DataAcces();
int idClient =Convert.ToInt16( CDGTXT.Text);
DateTime orderDate = DateTime.Now;
DateTime requireDate = ReleaseDate_Picker.Value;
int total = Convert.ToInt32( Total_TXT.Text);
if (requireDate.Equals(orderDate) || requireDate < orderDate)
{
MessageBox.Show("La fecha de entrega debe ser mayor a la fecha actual");
return;
}
Order order = new Order(idClient,orderDate,requireDate,total);
access.saveOrder(order);
foreach (DataGridViewRow row in dataGridView1.Rows)
{
int id = (int)row.Cells[0].Value;
int quantity = Convert.ToInt32( row.Cells[2].Value);
int price = (int)row.Cells[3].Value;
Product product = new Product(id, price, quantity);
access.saveOrderProducts(product);
}
formulario.RefreshDatagrid();
dataGridView1.Rows.Clear();
CDGTXT.Clear();
Total_TXT.Clear();
NOMTXT.Clear();
APTXT.Clear();
}
public void UpdateProduct(Product product)
{
command = new SqlCommand("UPDATE Productos SET Producto=@product, Cantidad=@quantity,Precio_Unidad=@price ,Comentario=@comment WHERE ID_Producto=@id", conecction);
parameter = new SqlParameter();
parameter.ParameterName = "@id";
parameter.Value = product.Id;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@product";
parameter.Value = product.Description;
parameter.SqlDbType = SqlDbType.VarChar;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@quantity";
parameter.Value = product.Quantity;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@price";
parameter.Value = product.Price;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@comment";
parameter.Value = product.Comment;
parameter.SqlDbType = SqlDbType.VarChar;
command.Parameters.Add(parameter);
try
{
conecction.Open();
command.ExecuteNonQuery();
MessageBox.Show("Producto Editado");
conecction.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error! " + ex);
}
finally
{
conecction.Close();
}
}
public void saveOrderProducts(Product product)
{
command = new SqlCommand("Insert into Pedidos (ID_Orden,ID_Producto,Cantidad,Precio) Values (@idOrder,@idProduct,@quantity,@price)", conecction);
int id =lastOrderId();
parameter = new SqlParameter();
parameter.ParameterName = "@idOrder";
parameter.Value = id;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@idProduct";
parameter.Value = product.Id;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@quantity";
parameter.Value =product.Quantity;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@price";
parameter.Value = product.Price;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
try
{
conecction.Open();
command.ExecuteNonQuery();
MessageBox.Show("pedido agregado");
conecction.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error! " + ex);
}
finally
{
conecction.Close();
}
}
public void insertProduct(Product product)
{
command = new SqlCommand("Insert into Productos (Producto,Precio_Unidad,Comentario) Values (@producto,@precio,@comentario)", conecction);
parameter = new SqlParameter();
parameter.ParameterName = "@producto";
parameter.Value = product.Description;
parameter.SqlDbType = SqlDbType.VarChar;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@precio";
parameter.Value = product.Price;
parameter.SqlDbType = SqlDbType.Int;
command.Parameters.Add(parameter);
parameter = new SqlParameter();
parameter.ParameterName = "@comentario";
parameter.Value = product.Comment;
parameter.SqlDbType = SqlDbType.VarChar;
command.Parameters.Add(parameter);
try
{
conecction.Open();
command.ExecuteNonQuery();
conecction.Close();
MessageBox.Show("Producto nuevo agregada");
}
catch (SqlException ex)
{
MessageBox.Show("Error ! " + ex);
}
finally
{
conecction.Close();
}
}