//Operaciones
public void AltaFactura(Factura factura)
{
SqlConnection conn = new SqlConnection(Conexion.Cnn);
SqlCommand command = new SqlCommand();
try
{
command.Connection = conn;
command.CommandText = "AltaFactura";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@FacID", factura.ID));
command.Parameters.Add(new SqlParameter("@FacAlta", factura.FechaAlta.ToString("yyyy-MM-dd HH:mm:ss")));
command.Parameters.Add(new SqlParameter("@FacCliente", factura.Cliente));
conn.Open();
int res = command.ExecuteNonQuery();
if (res == 1)
{
PersistenciaLineas pLines = new PersistenciaLineas();
foreach (LineaFactura lin in factura.Lineas)
{
pLines.AltaLineas(lin, factura.ID, conn);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public void ModificarFactura(Factura factura)
{
SqlConnection conn = new SqlConnection(Conexion.Cnn);
SqlCommand command = new SqlCommand();
try
{
command.Connection = conn;
command.CommandText = "ModificarFactura";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@FacID", factura.ID));
command.Parameters.Add(new SqlParameter("@Cliente", factura.Cliente));
conn.Open();
command.ExecuteNonQuery();
PersistenciaLineas pLineas = new PersistenciaLineas();
//Eliminamos todas las lineas
pLineas.EliminarLineas(factura.ID, conn);
//Cargamos las lineas nuevamente
foreach (LineaFactura lin in factura.Lineas)
{
pLineas.AltaLineas(lin, factura.ID, conn);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}