public static List <ComboCP> ObtainComboCP(int id)
{
SqlConnection Connection = Connecting.Connect();
List <ComboCP> ComboCP = new List <ComboCP>();
SqlCommand Command = new SqlCommand("selectClienteCombo", Connection);
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.AddWithValue("@IdCliente", id);
SqlDataReader DataReader = Command.ExecuteReader();
while (DataReader.Read())
{
ComboCP newCP = new ComboCP();
newCP.NombreC = DataReader.GetString(0);
newCP.Apellido = DataReader.GetString(1);
newCP.NombreP = DataReader.GetString(2);
newCP.PrecioP = DataReader.GetInt32(3);
newCP.Cantidad = DataReader.GetInt32(4);
newCP.Total = DataReader.GetInt32(5);
ComboCP.Add(newCP);
}
Connection.Close();
return(ComboCP);
}
public static List <Combos> ObtainCombos()
{
SqlConnection Connection = Connecting.Connect();
List <Combos> Combo = new List <Combos>();
SqlCommand Command = new SqlCommand("selectCombos", Connection);
Command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader DataReader = Command.ExecuteReader();
while (DataReader.Read())
{
Combos newCombo = new Combos();
newCombo.IdCliente = DataReader.GetInt32(0);
newCombo.NombreCli = DataReader.GetString(1);
newCombo.ApellidoCli = DataReader.GetString(2);
newCombo.IdProducto = DataReader.GetInt32(3);
newCombo.NombreP = DataReader.GetString(4);
newCombo.PrecioP = DataReader.GetInt32(5);
newCombo.CantidadP = DataReader.GetInt32(6);
Combo.Add(newCombo);
}
Connection.Close();
return(Combo);
}
public static void GuardarCombo(Combos combo)
{
SqlConnection Connection = Connecting.Connect();
SqlCommand Command = new SqlCommand("insertCombo", Connection);
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.AddWithValue("@Cantidad", combo.Cantidad);
Command.Parameters.AddWithValue("@IdC", combo.IdCliente);
Command.Parameters.AddWithValue("@IdP", combo.IdProducto);
Command.ExecuteNonQuery();
Connection.Close();
}
public static List <Combos> ObtainCombos()
{
SqlConnection Connection = Connecting.Connect();
List <Combos> Combo = new List <Combos>();
SqlCommand Command = new SqlCommand("selectCombos", Connection);
Command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader DataReader = Command.ExecuteReader();
while (DataReader.Read())
{
Combos newCombo = new Combos();
newCombo.IdCliente = DataReader.GetInt32(0);
newCombo.IdProducto = DataReader.GetInt32(1);
Combo.Add(newCombo);
}
Connection.Close();
return(Combo);
}
public static List <Client> ObtainClient()
{
SqlConnection Connection = Connecting.Connect();
List <Client> Clients = new List <Client>();
SqlCommand Command = new SqlCommand("selectClientes", Connection);
Command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader DataReader = Command.ExecuteReader();
while (DataReader.Read())
{
Client newClient = new Client();
newClient.IdClient = DataReader.GetInt32(0);
newClient.Nombre = DataReader.GetString(1);
newClient.Apellido = DataReader.GetString(2);
newClient.Fecha_Nacimiento = DataReader.GetString(3);
newClient.Direccion = DataReader.GetString(4);
Clients.Add(newClient);
}
Connection.Close();
return(Clients);
}
public static List <Product> ObtainProduct()
{
SqlConnection Connection = Connecting.Connect();
List <Product> Products = new List <Product>();
SqlCommand Command = new SqlCommand("selectProductos", Connection);
Command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader DataReader = Command.ExecuteReader();
while (DataReader.Read())
{
Product newProduct = new Product();
newProduct.IdProduc = DataReader.GetInt32(0);
newProduct.Nombre = DataReader.GetString(1);
newProduct.Descripcion = DataReader.GetString(2);
newProduct.Precio = DataReader.GetInt32(3);
newProduct.Stock = DataReader.GetInt32(4);
Products.Add(newProduct);
}
Connection.Close();
return(Products);
}