Esempio n. 1
0
        // DELETE api/leaguessettings/5
        // [HttpDelete]
        public void Delete(int id)
        {
            LeaguesSetting Ls = db.LeaguesSettings.Single(l => l.Id == id);

            db.LeaguesSettings.DeleteObject(Ls);
            db.SaveChanges();
        }
Esempio n. 2
0
        // PUT api/leaguessettings/5
        public dynamic Put(int id, [FromBody] LeaguesSetting value)
        {
            if (value == null || value.Id != id)
            {
                return("FAILURE");
            }

            //var uls = db.LeaguesSettings.Find(id);
            //if (uls == null)
            //{
            //    return "FAILURE";
            //}
            //uls.ClientID = value.ClientID;
            //uls.LeagueCode = value.LeagueCode;
            //uls.SettingsID  = value.SettingsID;
            //uls.OptionsID = value.OptionsID;

            //db.LeaguesSettings.Add(uls);
            bool exists = db.LeaguesSettings.Any(l => l.ClientID == value.ClientID && l.LeagueCode == value.LeagueCode && l.SettingsID == value.SettingsID && l.OptionsID == value.OptionsID && l.Id != id);

            if (!exists)
            {
                db.LeaguesSettings.Attach(value);
                db.ObjectStateManager.ChangeObjectState(value, EntityState.Modified);


                try
                {
                    db.SaveChanges();
                }
                catch (Exception e)
                {
                    return("FAILURE");
                }
                return(value);
            }
            else
            {
                return("Exists");
            }
        }
Esempio n. 3
0
        // POST api/leaguessettings

        public dynamic Post([FromBody] LeaguesSetting value)
        {
            // db.LeaguesSettings.Add(value);
            if (value.LeagueCode != null)
            {
                string ClientID = Request.Headers.GetValues("ClientID").FirstOrDefault().Replace('{', ' ').Replace('}', ' ').Trim();
                value.ClientID = Convert.ToInt32(ClientID);

                bool exists = db.LeaguesSettings.Any(l => l.ClientID == value.ClientID && l.LeagueCode == value.LeagueCode && l.SettingsID == value.SettingsID && l.OptionsID == value.OptionsID);
                if (!exists)
                {
                    db.LeaguesSettings.AddObject(value);
                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception e)
                    {
                        return("FAILURE");
                    }

                    var retvalue = new LeaguesSetting();
                    retvalue.Id         = value.Id;
                    retvalue.ClientID   = value.ClientID;
                    retvalue.LeagueCode = value.LeagueCode;
                    retvalue.SettingsID = value.SettingsID;
                    retvalue.OptionsID  = value.OptionsID;
                    return(retvalue);
                }
                else
                {
                    return("Exists");
                }
            }
            else
            {
                return("Error");
            }
        }