public JsonResult UpdateGame(List <UpdateGames> data) { var id = data[0].id; // Update t_game_master var update1 = from t in db.t_game_master where t.id == id select t; if (update1.Count() > 0) { foreach (t_game_master y in update1) { y.game_name = data[0].game_name; y.image = data[0].image; y.is_active = data[0].is_active; y.category = data[0].category; y.sub_category = data[0].sub_category; y.description = data[0].description; y.priority = data[0].priority; } db.SaveChanges(); } // Update t_game_detail List <GAMEUPDATEDETAIL> game_details = data[0].GAMEUPDATEDETAIL; foreach (GAMEUPDATEDETAIL obj in game_details) { var update2 = from s in db.t_game_detail where s.game_detail_id == obj.game_detail_id select s; if (update2.Count() > 0) { foreach (t_game_detail z in update2) { z.preference = obj.preference; z.trust = obj.trust; z.ratio = obj.ratio; z.possibility = obj.possibility; z.region = obj.region; z.game_code = obj.game_code; } db.SaveChanges(); } else if (update2.Count() <= 0) { t_game_detail _gamedetail = new t_game_detail(); _gamedetail.game_id = id; _gamedetail.preference = obj.preference; _gamedetail.trust = obj.trust; _gamedetail.ratio = obj.ratio; _gamedetail.possibility = obj.possibility; _gamedetail.region = obj.region; _gamedetail.game_code = obj.game_code; db.t_game_detail.Add(_gamedetail); db.SaveChanges(); } } return(Json(JsonRequestBehavior.AllowGet)); }
public JsonResult SaveGames(List <RootObject> data) { DateTime Now = DateTime.Now; string GameDayNamePrompt = (data[0].game_date.ToString("dddd", new CultureInfo("en-EN"))); string GameDay = (data[0].game_date.ToString("dd")); string GameDayName = (data[0].game_date.ToString("dddd", new CultureInfo("tr-TR"))); string GameMonth = (data[0].game_date.ToString("MMMM", new CultureInfo("tr-TR"))); string FullGameDay = GameDay + " " + GameMonth + ", " + GameDayName; ////////////// SET GAME PREFERENCE ////////////////// List <GAMEDETAIL> game_details = data[0].GAMEDETAIL; int maxPossibility = int.MinValue; string DetailPreference = ""; foreach (GAMEDETAIL type in game_details) { int prefDetail = Convert.ToInt32(type.possibility); if (prefDetail > maxPossibility) { maxPossibility = prefDetail; } } foreach (GAMEDETAIL obj in game_details) { if (obj.possibility == Convert.ToString(maxPossibility)) { DetailPreference = obj.preference; } } ////////////////////////////////////////////////////// t_game_master _gamemaster = new t_game_master(); _gamemaster.create_date = Now; _gamemaster.id = 0; _gamemaster.game_name = data[0].game_name; _gamemaster.image = data[0].image; _gamemaster.is_active = data[0].is_active; _gamemaster.category = data[0].category; _gamemaster.sub_category = data[0].sub_category; _gamemaster.description = data[0].description; _gamemaster.priority = data[0].priority; _gamemaster.game_date = data[0].game_date; _gamemaster.game_day_prompt = GameDayNamePrompt; _gamemaster.game_day = FullGameDay; _gamemaster.game_preference = DetailPreference + " - " + Convert.ToString(maxPossibility); db.t_game_master.Add(_gamemaster); int GameId = _gamemaster.id; foreach (GAMEDETAIL obj in game_details) { t_game_detail _gamedetail = new t_game_detail(); _gamedetail.game_id = GameId; _gamedetail.preference = obj.preference; _gamedetail.trust = obj.trust; _gamedetail.ratio = obj.ratio; _gamedetail.possibility = obj.possibility; _gamedetail.region = obj.region; _gamedetail.game_code = obj.game_code; db.t_game_detail.Add(_gamedetail); } db.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); }