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