public JsonResult SaveBets(List <BETMASTER> data)
{
DateTime Now = DateTime.Now;
t_bet_master _betmaster = new t_bet_master();
_betmaster.create_date = Now;
_betmaster.id = 0;
_betmaster.bet_name = data[0].bet_name;
_betmaster.is_active = data[0].is_active;
_betmaster.description = data[0].description;
db.t_bet_master.Add(_betmaster);
int BetId = _betmaster.id;
List <BETDETAIL> bet_details = data[0].BETDETAIL;
foreach (BETDETAIL obj in bet_details)
{
string GameDay = (obj.game_date.ToString("dd"));
string GameDayName = (obj.game_date.ToString("dddd",
new CultureInfo("tr-TR")));
string GameMonth = (obj.game_date.ToString("MMMM",
new CultureInfo("tr-TR")));
string FullGameDay = GameDay + " " + GameMonth + ", " + GameDayName;
t_bet_detail _betdetail = new t_bet_detail();
_betdetail.bet_id = BetId;
_betdetail.preference = obj.preference;
_betdetail.trust = obj.trust;
_betdetail.ratio = obj.ratio;
_betdetail.possibility = obj.possibility;
_betdetail.game_code = obj.game_code;
_betdetail.game_name = obj.game_name;
_betdetail.game_date = obj.game_date;
_betdetail.game_date_prompt = FullGameDay;
db.t_bet_detail.Add(_betdetail);
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateBet(List <BETMASTERUPDATE> data)
{
var id = data[0].id;
// Update t_bet_master
var update1 = from t in db.t_bet_master where t.id == id select t;
if (update1.Count() > 0)
{
foreach (t_bet_master y in update1)
{
y.bet_name = data[0].bet_name;
y.is_active = data[0].is_active;
y.description = data[0].description;
}
db.SaveChanges();
}
// Update t_bet_detail
List <BETDETAILUPDATE> bet_details = data[0].BETDETAILUPDATE;
foreach (BETDETAILUPDATE obj in bet_details)
{
var update2 = from s in db.t_bet_detail where s.id == obj.id select s;
if (update2.Count() > 0)
{
foreach (t_bet_detail z in update2)
{
z.preference = obj.preference;
z.trust = obj.trust;
z.ratio = obj.ratio;
z.possibility = obj.possibility;
z.game_code = obj.game_code;
z.game_name = obj.game_name;
}
db.SaveChanges();
}
else if (update2.Count() <= 0)
{
t_bet_detail _betdetail = new t_bet_detail();
_betdetail.bet_id = id;
_betdetail.preference = obj.preference;
_betdetail.trust = obj.trust;
_betdetail.ratio = obj.ratio;
_betdetail.possibility = obj.possibility;
_betdetail.game_code = obj.game_code;
_betdetail.game_name = obj.game_name;
db.t_bet_detail.Add(_betdetail);
db.SaveChanges();
}
}
return(Json(JsonRequestBehavior.AllowGet));
}
