Esempio n. 1
0
        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);
        }