Exemplo n.º 1
0
        public static int?UpdateBalance(string NAVDatabaseName, string NAVCompanyName, string NAVClientNo, string EntryNo, string SinalizacaoRec, string Obs)
        {
            try
            {
                var result = new List <NAVClientesBalanceControlViewModel>();
                using (var ctx = new SuchDBContextExtention())
                {
                    var _parameters = new[] {
                        new SqlParameter("@DBName", NAVDatabaseName),
                        new SqlParameter("@CompanyName", NAVCompanyName),
                        new SqlParameter("@CustomerNo", NAVClientNo),
                        new SqlParameter("@Obs", Obs),
                        new SqlParameter("@SinalizacaoRec", SinalizacaoRec),
                        new SqlParameter("@EntryNo", EntryNo)
                    };

                    var data = ctx.execStoredProcedureNQ("exec NAV2017ClientesBalancesUpdate @DBName, @CompanyName, @CustomerNo, @Obs, @SinalizacaoRec, @EntryNo", _parameters);

                    return(data);
                }
            }
            catch (Exception ex)
            {
                return(null);
            }
        }