public static List <Abastecimento> Sync(List <Abastecimento> lista)
{
List <Abastecimento> abastecimentos = null;
string sql = "EXEC SyncAbastecimentos @Datahora, @Desc, @Func, @Id, @IdBico, @IdCombustivel, " +
"@IdFuncionario, @IdTipoPreco, @Litros, @NumeroBico, @Preco, " +
"@PrevalecePrecoBico, @Selecionar, @Total";
try
{
SqlConnection conn = DBAccess.GetConnection();
try
{
int count = 0;
foreach (Abastecimento a in lista)
{
if (count == 0)
{
conn.Open();
}
SqlCommand command = new SqlCommand(sql, conn);
command.Parameters.Add(new SqlParameter("@Datahora", a.DataHora));
command.Parameters.Add(new SqlParameter("@Desc", a.Descricao));
command.Parameters.Add(new SqlParameter("@Func", a.Funcionario));
command.Parameters.Add(new SqlParameter("@Id", a.Id));
command.Parameters.Add(new SqlParameter("@IdBico", a.IdBico));
command.Parameters.Add(new SqlParameter("@IdCombustivel", a.IdCombustivel));
command.Parameters.Add(new SqlParameter("@IdFuncionario", a.IdFuncionario));
command.Parameters.Add(new SqlParameter("@IdTipoPreco", a.IdTipoPreco));
command.Parameters.Add(new SqlParameter("@Litros", a.Litros));
command.Parameters.Add(new SqlParameter("@NumeroBico", a.NumeroBico));
command.Parameters.Add(new SqlParameter("@Preco", a.Preco));
command.Parameters.Add(new SqlParameter("@PrevalecePrecoBico", a.PrevalecePrecoBico));
command.Parameters.Add(new SqlParameter("@Selecionar", a.Selecionar));
command.Parameters.Add(new SqlParameter("@Total", a.Total));
command.ExecuteNonQuery();
count++;
}
string query = "SELECT * FROM abastecimento";
abastecimentos = GetData(query);
}
catch (NullReferenceException e)
{
Util.WriteLog.Write("" + e, Util.ENUM.LOG_FILENAME_SYSTEM);
}
finally
{
conn.Close();
}
}
catch (SqlException e)
{
Util.WriteLog.Write("" + e, Util.ENUM.LOG_FILENAME_DB);
}
return(abastecimentos);
}