public Producer AddProducer(Producer producer, string spName, string providerName, string connectionString)
{
try
{
var parameters = RepositoryHelper.CreateProducerSqlParameters(producer);
var paramsArray = parameters.ToArray();
string storedProcedure = MasterDataManager.ConfigData["AddProducer"];
using (SqlConnection connection = (SqlConnection)RepositoryHelper.OpenConnection(providerName, connectionString))
{
try
{
var sqlCommand = new SqlCommand()
{
Connection = connection,
CommandText = storedProcedure,
CommandType = CommandType.StoredProcedure
};
sqlCommand.Parameters.AddRange(paramsArray);
sqlCommand.ExecuteNonQuery();
producer.ProducerID = Convert.ToInt32((paramsArray.FirstOrDefault(a => a.ParameterName == "@ProducerID").Value.ToString()));
}
catch (System.Exception ex)
{
throw;
}
finally
{
connection.Close();
}
}
}
catch (System.Exception ex)
{
throw;
}
return(producer);
}