Beispiel #1
0
        public long UpdateVAT(Models.AppVCA04VATView data)
        {
            try
            {
                SqlParameter pOriginal  = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnamevatoutput), this._paramnamevatupdate);
                var          parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameVATU, parameters);

                return(data.DocumentVATID);
            }
            catch (Exception)
            {
                throw;
            }
        }
Beispiel #2
0
        public long InsertVAT(Models.AppVCA04VATView data)
        {
            try
            {
                SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnamevatoutput).ToArray();
                this._db.Database.ExecuteSqlCommand(this._storeNameVATI, parameters);
                data.DocumentVATID = (long)parameters.GetValueSqlParam(this._paramnamevatoutput);

                return(data.DocumentVATID);
            }
            catch (Exception)
            {
                throw;
            }
        }