public int Save(CompraGado compraGado)
{
var connString = Constants.MarfrigDbConnection;
int novaCompraId = 0;
using (SqlConnection conn = new SqlConnection(connString))
{
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(" INSERT INTO CompraGado ");
sql.AppendLine(" (DataEntrega, PecuaristaID) ");
sql.AppendLine(" VALUES ");
sql.AppendFormat("('{0}', {1}) ; ", compraGado.DataEntrega.ToString("yyyy-MM-dd"), compraGado.PecuaristaID);
SqlCommand sqlCommand = new SqlCommand(sql.ToString(), conn);
conn.Open();
sqlCommand.ExecuteNonQuery();
conn.Close();
string sqlRetorno = "SELECT TOP 1 * FROM CompraGado ORDER BY Id DESC";
SqlCommand sqlCommandRetorno = new SqlCommand(sqlRetorno, conn);
conn.Open();
var objDataReader = sqlCommandRetorno.ExecuteReader();
if (objDataReader.HasRows)
{
var compraRetorno = OrMappingBasico(objDataReader);
novaCompraId = compraRetorno.FirstOrDefault().Id;
}
conn.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
}
return(novaCompraId);
}
private List <CompraGado> OrMappingBasico(SqlDataReader reader)
{
var compraGadoList = new List <CompraGado>();
while (reader.Read())
{
var compraGado = new CompraGado()
{
Id = Convert.ToInt32(reader["Id"]),
DataEntrega = Convert.ToDateTime(reader["DataEntrega"]),
PecuaristaID = Convert.ToInt32(reader["PecuaristaID"])
};
compraGadoList.Add(compraGado);
}
return(compraGadoList);
}
