public void UpdateUserDraftPriority(HttpPostDraftData DraftPriorities) { JavaScriptSerializer ser = new JavaScriptSerializer(); IList<PriorityData> newData = ser.Deserialize<IList<PriorityData>>(DraftPriorities.DraftPriorities); // logger //var sw = new System.IO.StreamWriter("C:\\Users\\arogier\\Desktop\\log.txt", true); //sw.WriteLine("CONTROLLER:"); //sw.WriteLine(newData.ToString()); //sw.WriteLine(DraftPriorities.ToString()); //sw.Close(); DataTable priorityData = new DataTable(); DataColumn col1 = new DataColumn(); col1.DataType = System.Type.GetType("System.Int32"); col1.ColumnName = "Character_PK"; priorityData.Columns.Add(col1); DataColumn col2 = new DataColumn(); col2.DataType = System.Type.GetType("System.Int32"); col2.ColumnName = "User_FK"; priorityData.Columns.Add(col2); DataColumn col3 = new DataColumn(); col3.DataType = System.Type.GetType("System.Int32"); col3.ColumnName = "Priority"; priorityData.Columns.Add(col3); foreach(var i in newData) { DataRow newRow = priorityData.NewRow(); newRow["Character_PK"] = i.Character_PK; newRow["User_FK"] = DraftPriorities.UserFK; newRow["Priority"] = i.Priority; priorityData.Rows.Add(newRow); } using (var connection = new SqlConnection(DataProvider.Instance().ConnectionString)) { using (var command = new SqlCommand("RPGFL_UpdateUserDraftPriority", connection)) { //Setup Parameters command.CommandType = CommandType.StoredProcedure; var tableParam = new SqlParameter("@CharPriority", priorityData); tableParam.TypeName = "dbo.RPGFL_CharacterPriority"; tableParam.SqlDbType = SqlDbType.Structured; command.Parameters.Add(tableParam); //Open connection and call connection.Open(); command.ExecuteReader(); } } }
public HttpResponseMessage UpdateUserDraftPriority(HttpPostDraftData DraftPriorities) { try { // logger //var sw = new System.IO.StreamWriter("C:\\Users\\arogier\\Desktop\\log.txt", true); //sw.WriteLine("WEBSERVICES:"); //sw.WriteLine(DraftPriorities); //sw.WriteLine(" "); //sw.WriteLine(DraftPriorities.DraftPriorities); //sw.WriteLine(DraftPriorities.UserFK); //sw.Close(); controller.UpdateUserDraftPriority(DraftPriorities); return Request.CreateResponse(HttpStatusCode.OK, "SUCCESS"); } catch (Exception exc) { return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc); } }