public static void EditScheduleGame(Game result) { if (ConfigurationManager.ConnectionStrings["DefaultConnection"] != null) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { var sp = new SqlCommand("EditScheduleGame", con); sp.CommandType = CommandType.StoredProcedure; sp.Parameters.AddWithValue("ID", result.ID); sp.Parameters.AddWithValue("DateOfGame", result.DateOfGame); sp.Parameters.AddWithValue("Player1", result.Player1SelectedItemId); sp.Parameters.AddWithValue("Player2", result.Player2SelectedItemId); con.Open(); sp.ExecuteNonQuery(); } } }
public ActionResult Edit(Game model) { if (ModelState.IsValid) { ScheduleRepo.EditScheduleGame(model); Twitter.Tweet(model.TwitterEdited); } return RedirectToAction("ListScheduledGames", "Schedule"); }
public ActionResult ScheduleGame() { ViewBag.Title = "Schedule"; ViewBag.Message = "Schedule a game to be played"; var model = new Game(); model.DateOfGame = DateTime.Today; return View(model); }
public static List<Game> GetScheduledGames(List<Player> Players) { if (ConfigurationManager.ConnectionStrings["DefaultConnection"] != null) { var table = new List<Game>(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { SqlDataAdapter da = new SqlDataAdapter("select * from vScheduleGames ORDER BY ScheduledDate", con); DataSet ds = new DataSet(); da.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { var item = new Game() { ID = int.Parse(dr["ID"].ToString()), DateOfGame = DateTime.Parse(dr["ScheduledDate"].ToString()), Player1SelectedItemId = int.Parse(dr["Player1"].ToString()), Player2SelectedItemId = int.Parse(dr["Player2"].ToString()), }; table.Add(item); } } return table; } return null; }