// GET api/<controller>/5 public Board Get(int id) { string query = "SELECT * FROM poz1 WHERE poz_id=@poz_id"; SqlCommand insertname = new SqlCommand(); List<string> listboard = new List<string>(); DataSet ds = new DataSet(); SqlDataAdapter da; var board = new Board { Id = id }; try { insertname.CommandType = CommandType.Text; insertname.CommandText = query; var conn = connect("puzzlepush"); insertname = new SqlCommand(query, conn); insertname.Parameters.Add(new SqlParameter("@poz_id", id)); da = new SqlDataAdapter(query, conn); da.Fill(ds, "loadboard"); DataTable dt = new DataTable(); dt = ds.Tables["loadboard"]; conn.Close(); List<string> stringlist = new List<string>(); for (int i = 0; i < dt.Rows.Count; i++) { string s = (string)dt.Rows[i]["loadboard"]; stringlist.Add(s); } //makes a 2D array from the dataTable List for (int i = 0; i < 5; i++) { for (int j = 0; j < 5; j++) { String n = stringlist[i]; board.arrayboard[i, j] = n; }; } } catch (Exception ex) { //json = JsonConvert.SerializeObject("saveboard" + ex); Debug.WriteLine(ex.Message); } return board; }
// POST api/<controller> public void Post(Board board) { List<string> listboard = new List<string>(); try { foreach (string image in board.arrayboard) { listboard.Add(image); } var conn = connect("puzzlepush"); SqlCommand insertname = new SqlCommand("insertboard", conn); insertname.CommandType = CommandType.StoredProcedure; Debug.Write(insertname); insertname.Parameters.Add(new SqlParameter("@P_id",board.playerid)); for (int k = 0; k < listboard.Count; k++) { string valparm = "@poz" + k + ""; //insertname.Parameters.AddWithValue(valparm, listboard[k]); insertname.Parameters.Add(new SqlParameter(valparm, listboard[k])); } var boardID = insertname.ExecuteScalar(); board.Id = Convert.ToInt32(boardID); conn.Close(); } catch (Exception ex) { //json = JsonConvert.SerializeObject("saveboard" + ex); Debug.WriteLine(ex.Message); //Console.WriteLine(); } }
public static string saveboard(Board test) { string json; string query=""; SqlCommand insertname = new SqlCommand(); List<string> listboard = new List<string>(); try { foreach(string image in test.arrayboard) { listboard.Add(image); } string header = "INSERT INTO poz "; string cols = "(poz0"; string vals = "VALUES ('@" + listboard[0] + "'"; for (int i = 1; i < listboard.Count; i++) { cols += ",poz" + i; vals += ",'@" + listboard[i] + "'"; } cols += ") "; vals += ")"; query = header + cols + vals; insertname.CommandType = CommandType.Text; insertname.CommandText = query; insertname = new SqlCommand(query, connect("puzzlepush")); /*for(int k = 0; k<listboard.Count;k++) { string valparm = "@poz" + k + ""; //insertname.Parameters.AddWithValue(valparm, listboard[k]); insertname.Parameters.Add(new SqlParameter(valparm, listboard[k])); }*/ recordsin = insertname.ExecuteNonQuery(); conn.Close(); json = JsonConvert.SerializeObject(insertname); } catch (Exception ex) { json = JsonConvert.SerializeObject("saveboard"+ex); Debug.WriteLine(json); Debug.WriteLine(recordsin); } return query; }