/// <summary>
/// Metodo para Crear un registro de SalidaSacrificio
/// </summary>
/// <param name="info">Valores de la entidad que será creada</param>
public void Crear(SalidaSacrificioInfo info)
{
try
{
Logger.Info();
Dictionary <string, object> parameters = AuxSalidaSacrificioDAL.ObtenerParametrosCrear(info);
//int result = Create("SalidaSacrificio_Crear", parameters);
using (var connection = new SqlConnection(this.ConnectionString))
{
var command = new SqlCommand("SalidaSacrificio_Crear", connection);
foreach (var param in parameters)
{
IDbDataParameter parameter = new SqlParameter(string.Format("{0}", param.Key), param.Value ?? DBNull.Value);
command.Parameters.Add(parameter);
}
command.Connection.Open();
command.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (DataException ex)
{
Logger.Error(ex);
throw new ExcepcionServicio(MethodBase.GetCurrentMethod(), ex);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new ExcepcionDesconocida(MethodBase.GetCurrentMethod(), ex);
}
}
public bool CrearLista(IList <SalidaSacrificioInfo> salidaSacrificio, string conexion)
{
var result = false;
try
{
Logger.Info();
using (var connection = new SqlConnection(conexion))
{
connection.Open();
var command = new SqlCommand("SalidaSacrificio_Crear", connection);
command.CommandType = CommandType.StoredProcedure;
foreach (var salida in salidaSacrificio.GroupBy(e => e.NUM_CORR))
{
var corralSacrificar = salida.FirstOrDefault();
command.Parameters.Clear();
Dictionary <string, object> parameters = AuxSalidaSacrificioDAL.ObtenerParametrosCrear(corralSacrificar);
foreach (var param in parameters)
{
IDbDataParameter parameter = new SqlParameter(string.Format("{0}", param.Key), param.Value ?? DBNull.Value);
command.Parameters.Add(parameter);
}
command.ExecuteNonQuery();
}
}
result = true;
}
catch (SqlException ex)
{
if (ex.Message.Contains("Violation of PRIMARY KEY constraint 'PK_ConfiguracionVisceraCorral'"))
{
}
Logger.Error(ex);
}
catch (DataException ex)
{
Logger.Error(ex);
}
catch (Exception ex)
{
Logger.Error(ex);
}
return(result);
}