Esempio n. 1
0
        public async Task <HttpResponseMessage> GetSaveItemFull(ItemDetailFullVM model)
        {
            try
            {
                string username = Thread.CurrentPrincipal.Identity.Name;

                return(Request.CreateResponse <IEnumerable <SaveReturnVM> >(HttpStatusCode.OK, await UOW.GetSaveItemFull(model)));
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
            }
        }
Esempio n. 2
0
        public async Task <IEnumerable <SaveReturnVM> > GetSaveItemFull(ItemDetailFullVM model)
        {
            try
            {
                string xml             = ObjectToXMLGeneric(model);
                var    queryParameters = new DynamicParameters();
                queryParameters.Add("@xml", xml);
                string sql = "SP_Process_SaveItemFull";



                using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SysConn"].ConnectionString))
                {
                    var val = await db.QueryAsync <SaveReturnVM>(sql, queryParameters, commandType : CommandType.StoredProcedure);

                    return(val);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }