public HttpResponseMessage Post([FromBody] All userData) { return(Request.CreateResponse(HttpStatusCode.OK, SamgoGameHelper.AddUserData(userData))); //UserBuild ub = new UserBuild(); //userData.Time = Function.GetUTCTime(); //SamgoModels.UserInfo ui = new SamgoModels.UserInfo(); //UserValue uLord = new UserValue(); //UserValue uProsperity = new UserValue(); //UserPower up = new UserPower(); //UserTechnique ut = new UserTechnique(); //UserOrdnance uo = new UserOrdnance(); //var userInfo = new SamgoModels.UserInfo(); //userData.SeqNo = DapperHelper.Search<int>( // connectionString, " exec [samgo_add_user_and_group] N'" + // userData.Role + "' , N'" + userData.Legion + "'").FirstOrDefault(); //ConvertDataToModels(ref ub, ref ui, ref uLord, ref uProsperity, ref up, userData); //DapperHelper.InsertSQLNormal<UserBuild>(connectionString, "Build", ub); ////DapperHelper.InsertSQL<SamgoModels.UserInfo>(connectionString, "SamgoGame", ui); //DapperHelper.InsertSQLNormal<UserValue>(connectionString, "Lord", uLord); //DapperHelper.InsertSQLNormal<UserValue>(connectionString, "Prosperity", uProsperity); //DapperHelper.InsertSQLNormal<UserPower>(connectionString, "SamgoGamePower", up); //ConvertDataToModels(ref ut, ref uo, userData); //DapperHelper.InsertSQLNormal<UserTechnique>(connectionString, "Technique", ut); //var response = DapperHelper.InsertSQLNormal<UserOrdnance>(connectionString, "Ordnance", uo); //return Request.CreateResponse(HttpStatusCode.OK, userData.SeqNo); }
public HttpResponseMessage Get() { var allData = DapperHelper.Search <AllString>(SamgoGameHelper.connectionString, "exec [samgo_get_user_info_list]"); int count = 3; return(Request.CreateResponse(HttpStatusCode.OK, SamgoGameHelper.FillDataForView(allData, count))); }
public HttpResponseMessage PostUserSearch(Inner data) { AllString ob = new AllString(); try { UserDetail uDetail = new UserDetail(); UserData ud = DapperHelper.Search <UserData>(SamgoGameHelper.connectionString, "exec [samgo_get_user_info] N'" + data.Role + "', N'" + data.Legion + "'").FirstOrDefault(); uDetail = DapperHelper.Search <UserDetail>(SamgoGameHelper.connectionString, "exec [samgo_get_user_tech_info] N'" + data.Role + "', N'" + data.Legion + "'").FirstOrDefault(); SamgoGameHelper.ConvertDataToModels(ref ob, ud, uDetail); } catch (Exception) { } if (ob.Role == null) { ob.Role = data.Role; ob.Legion = data.Legion; } return(Request.CreateResponse(HttpStatusCode.OK, ob)); }