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