//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(); } }