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