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)); } }
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; } }