Exemplo n.º 1
0
        protected void rGridPlayer_DeleteCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            PlayerDomainModel         PlayerDM         = new PlayerDomainModel();
            PlayerPositionDomainModel PlayerPositionDM = new PlayerPositionDomainModel();

            try
            {
                PlayerDM.PlayerGUID         = (Guid)e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["PlayerGUID"];
                PlayerPositionDM.PlayerGUID = (Guid)e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["PlayerGUID"];

                PlayerPostionBLL.DeletePlayerPosition(PlayerPositionDM);
                PlayerBLL.DeletePlayer(PlayerDM);
                rGridPlayer.Rebind();
            }

            catch (Exception ex)
            {
                StackTrace st        = new StackTrace();
                StackFrame sf        = st.GetFrame(0);
                string     errMethod = sf.GetMethod().Name.ToString();                                           // Get the current method name
                string     errMsg    = "600";                                                                    // Gotta pass something, we're retro-fitting an existing method
                Session["LastException"] = ex;                                                                   // Throw the exception in the session variable, will be used in error page
                string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL
                Response.Redirect(url);                                                                          // Go to the error page.
            }
        }
Exemplo n.º 2
0
        protected void rLBPlayer_SelectedIndexChanged(object sender, EventArgs e)
        {
            var  strPlayerGUID = rLBPlayer.SelectedValue;
            Guid PlayerGuid    = Guid.Parse(strPlayerGUID);

            hddPlayerGUID.Value = strPlayerGUID;

            PlayerDomainModel Player = PlayerBLL.PlayerDetail(PlayerGuid);

            if (Player.PlayerImage != null)
            {
                imgPlayer.DataValue = Player.PlayerImage;
                imgPlayer.Visible   = true;
                imgPlayer.DataBind();
            }
            else
            {
                imgPlayer.Visible = false;
            }
            hddSeasonID.Value   = "0"; // I want all seasons
            hddPlayerGUID.Value = PlayerGuid.ToString();
            hddPrimPosID.Value  = rDDPosition.SelectedValue.ToString();

            //PlayerDrafted.PlayerGUID = PlayerGuid;
            //BindStatsGrid(PlayerDrafted);
        }
Exemplo n.º 3
0
 public void DeletePlayer(PlayerDomainModel player)
 {
     using (CSBAAzureEntities context = new CSBAAzureEntities())
     {
         var cPlayer = (from n in context.Players where n.PlayerGUID == player.PlayerGUID select n).FirstOrDefault();
         context.Players.Remove(cPlayer);
         context.SaveChanges();
     }
 }
Exemplo n.º 4
0
 public void UpdatePlayer(PlayerDomainModel player)
 {
     using (CSBAAzureEntities context = new CSBAAzureEntities())
     {
         var cPlayer = context.Players.Find(player.PlayerGUID);
         if (cPlayer != null)
         {
             cPlayer.PlayerName  = player.PlayerName;
             cPlayer.PlayerImage = player.PlayerImage;
             context.SaveChanges();
         }
     }
 }
        public PlayerDomainModel getPlayer(int id)
        {
            Players           player = playerRepository.SingleOrDefault(m => m.playerId == id);
            PlayerDomainModel pDM    = new PlayerDomainModel();

            pDM.playerId   = player.playerId;
            pDM.teamId     = player.teamId;
            pDM.playerName = player.playerName;
            pDM.position   = player.position;
            pDM.skill      = player.skill;
            pDM.isPlaying  = player.isPlaying;

            return(pDM);
        }
Exemplo n.º 6
0
        public PlayerDomainModel PlayerDetail(Guid?PlayerGUID)
        {
            PlayerDomainModel player = new PlayerDomainModel();

            using (CSBAAzureEntities context = new CSBAAzureEntities())
            {
                player = (from result in context.Players
                          where (result.PlayerGUID == PlayerGUID)
                          select new PlayerDomainModel
                {
                    PlayerGUID = result.PlayerGUID,
                    PlayerName = result.PlayerName,
                    PlayerImage = result.PlayerImage
                }).Single();
            } // Guaranteed to close the Connection

            return(player);
        }
Exemplo n.º 7
0
        public PlayerDomainModel InsertPlayer(PlayerDomainModel player)
        {
            using (CSBAAzureEntities context = new CSBAAzureEntities())
            {
                var _cPlayer = new Player
                {
                    PlayerName  = player.PlayerName,
                    PlayerImage = player.PlayerImage
                };
                context.Players.Add(_cPlayer);
                context.SaveChanges();

                // pass TeamID back to BLL
                player.PlayerGUID = _cPlayer.PlayerGUID;

                return(player);
            }
        }
Exemplo n.º 8
0
        public string AddEditPlayer()
        {
            PlayerViewModel vm     = new PlayerViewModel();
            string          result = "";

            //vm.playerId = 5;
            vm.playerName = "Testasdasd123123";
            vm.position   = "GK";
            vm.skill      = 5;
            vm.teamId     = 2;

            PlayerDomainModel dm = new PlayerDomainModel();

            AutoMapper.Mapper.Map(vm, dm);
            //result = playerBusiness.AddUpdatePlayer(dm);

            return(result);
        }
Exemplo n.º 9
0
        protected void rGridPlayer_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            try
            {
                PlayerDomainModel Player = new PlayerDomainModel();

                rGridPlayer.DataSource = PlayerBLL.ListDraftPlayers();
            }
            catch (Exception ex)
            {
                StackTrace st        = new StackTrace();
                StackFrame sf        = st.GetFrame(0);
                string     errMethod = sf.GetMethod().Name.ToString();                                           // Get the current method name
                string     errMsg    = "600";                                                                    // Gotta pass something, we're retro-fitting an existing method
                Session["LastException"] = ex;                                                                   // Throw the exception in the session variable, will be used in error page
                string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL
                Response.Redirect(url);                                                                          // Go to the error page.
            }
        }
Exemplo n.º 10
0
        public List <v_Stat_Hitter_ViewDomainModel> GetStats(PlayerDomainModel player)
        {
            //Create a return type Object
            List <v_Stat_Hitter_ViewDomainModel> list = new List <v_Stat_Hitter_ViewDomainModel>();

            //Create a Context object to Connect to the database
            using (CSBAAzureEntities context = new CSBAAzureEntities())
            {
                list = (from result in context.v_Stat_Hitter_View
                        select new v_Stat_Hitter_ViewDomainModel
                {
                    AB = result.AB,
                    Agility = result.Agility,
                    AVG = result.AVG,
                    BB = result.BB,
                    CS = result.CS,
                    Doubles = result.Doubles,
                    EBH = result.EBH,
                    FLDP1 = result.FLDP1,
                    FLDP2 = result.FLDP2,
                    Hits = result.Hits,
                    HP = result.HP,
                    HR = result.HR,
                    Ks = result.Ks,
                    OBA = result.OBA,
                    PlayerGUID = result.PlayerGUID,
                    PlayerName = result.PlayerName,
                    Rangep1 = result.Rangep1,
                    RangeP2 = result.RangeP2,
                    RBI = result.RBI,
                    RN = result.RN,
                    Runs = result.Runs,
                    SB = result.SB,
                    SeasonName = result.SeasonName,
                    SLG = result.SLG,
                    TB = result.TB,
                    Triples = result.Triples
                }).ToList();
            } // Guaranteed to close the Connection
            //return the list
            return(list);
        }
        public ActionResult GetPlayer(int playerId)
        {
            PlayerDomainModel            pDM    = playerBusiness.getPlayer(playerId);
            PlayerSkillsDomainModel      sDM    = playerSkillBusiness.getPlayerSkills(pDM.skill);
            PlayerSkillRelationViewModel result = new PlayerSkillRelationViewModel();

            PlayerViewModel      pVM = new PlayerViewModel();
            PlayerSkillViewModel sVM = new PlayerSkillViewModel();

            AutoMapper.Mapper.Map(pDM, pVM);
            AutoMapper.Mapper.Map(sDM, sVM);

            result.PlayerVM = pVM;
            result.SkillVM  = sVM;

            ViewBag.TeamList = new SelectList(getTeamVM(), "teamId", "teamName");
            ViewBag.playerId = playerId;

            return(PartialView("EditPlayerPartial", result));
        }
        public string AddEditPlayer(PlayerSkillRelationViewModel vm)
        {
            //PlayerViewModel vm = new PlayerViewModel();
            string result = "";

            //vm.playerId = 5;
            //vm.playerName = "Testasdasd123123";
            //vm.position = "GK";
            //vm.skill = 5;
            //vm.teamId = 2;

            PlayerDomainModel       dm      = new PlayerDomainModel();
            PlayerSkillsDomainModel skillDM = new PlayerSkillsDomainModel();

            AutoMapper.Mapper.Map(vm.SkillVM, skillDM);
            int skillID = playerSkillBusiness.AddUpdatePlayerSkill(skillDM);

            AutoMapper.Mapper.Map(vm.PlayerVM, dm);
            result = result + " " + playerBusiness.AddUpdatePlayer(dm, skillID);

            return(result);
        }
Exemplo n.º 13
0
        public string AddUpdatePlayer(PlayerDomainModel dm, int skillID)
        {
            string result = "";

            if (dm.playerId > 0) // Edit Player
            {
                Players player = playerRepository.SingleOrDefault(x => x.playerId == dm.playerId);

                if (player != null)
                {
                    player.playerName = dm.playerName;
                    player.position   = dm.position;
                    player.skill      = skillID;
                    player.teamId     = dm.teamId;

                    playerRepository.Update(player);

                    result = "Updated";
                }
            }
            else // Add Player
            {
                Players player = new Players();

                player.playerName = dm.playerName;
                player.position   = dm.position;
                player.skill      = skillID;
                player.teamId     = dm.teamId;

                playerRepository.Insert(player);

                result = "Added";
            }

            return(result);
        }
Exemplo n.º 14
0
        protected void rGridPlayer_UpdIns(object sender, GridCommandEventArgs e, string Action)
        {
            try
            {
                GridEditableItem          eeditedItem      = e.Item as GridEditableItem;
                PlayerDomainModel         PlayerDM         = new PlayerDomainModel();
                PlayerPositionDomainModel PlayerPositionDM = new PlayerPositionDomainModel();

                if (Action == "Update")
                {
                    PlayerDM.PlayerGUID = new Guid((eeditedItem.FindControl("lblPlayerGUID") as Label).Text.ToString());
                }
                PlayerDM.PlayerName = (eeditedItem.FindControl("rTBPlayerName") as RadTextBox).Text.Trim();

                // Deal with the image
                var aUpload = (eeditedItem.FindControl("AsyncUpload1") as RadAsyncUpload);
                if (aUpload.UploadedFiles.Count > 0)
                {
                    EditableImage img = new EditableImage((MemoryStream)Context.Cache.Get(Session.SessionID + "UploadedFile"));
                    MemoryStream  s   = new MemoryStream();
                    img.Image.Save(s, img.RawFormat);
                    byte[] imgData = s.ToArray();
                    PlayerDM.PlayerImage = imgData;
                }
                else
                {
                    PlayerDM.PlayerImage = null;
                }

                // Setup PlayerPositionDM
                if (Convert.ToInt32(((eeditedItem.FindControl("rDDPrimPos") as RadDropDownList)).SelectedValue) == 0)
                {
                    PlayerPositionDM.PrimaryPositionID = null;
                }
                else
                {
                    PlayerPositionDM.PrimaryPositionID = Convert.ToInt32(((eeditedItem.FindControl("rDDPrimPos") as RadDropDownList)).SelectedValue);
                }

                if (Convert.ToInt32(((eeditedItem.FindControl("rDDSecPos") as RadDropDownList)).SelectedValue) == 0)
                {
                    PlayerPositionDM.SecondaryPostiionID = null;
                }
                else
                {
                    PlayerPositionDM.SecondaryPostiionID = Convert.ToInt32(((eeditedItem.FindControl("rDDSecPos") as RadDropDownList)).SelectedValue);
                }

                if (Action == "Update")
                {
                    PlayerPositionDM.PlayerGUID = new Guid((eeditedItem.FindControl("lblPlayerGUID") as Label).Text.ToString());
                    PlayerPostionBLL.DeletePlayerPosition(PlayerPositionDM);
                    PlayerBLL.UpdatePlayer(PlayerDM);
                    PlayerPostionBLL.UpdatePlayerPosition(PlayerPositionDM);
                }
                else if (Action == "Insert")
                {
                    PlayerBLL.InsertPlayer(PlayerDM);
                    PlayerPositionDM.PlayerGUID = PlayerDM.PlayerGUID;
                    PlayerPostionBLL.InsertPlayerPosition(PlayerPositionDM);
                }

                //rGridPlayer.Rebind();
            }
            catch (Exception ex)
            {
                StackTrace st        = new StackTrace();
                StackFrame sf        = st.GetFrame(0);
                string     errMethod = sf.GetMethod().Name.ToString();                                           // Get the current method name
                string     errMsg    = "600";                                                                    // Gotta pass something, we're retro-fitting an existing method
                Session["LastException"] = ex;                                                                   // Throw the exception in the session variable, will be used in error page
                string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL
                Response.Redirect(url);                                                                          // Go to the error page.
            }
        }
Exemplo n.º 15
0
 public void DeletePlayer(PlayerDomainModel player)
 {
     dal.DeletePlayer(player);
 }
Exemplo n.º 16
0
 public PlayerDomainModel InsertPlayer(PlayerDomainModel player)
 {
     return(dal.InsertPlayer(player));
 }
Exemplo n.º 17
0
 public void UpdatePlayer(PlayerDomainModel player)
 {
     dal.UpdatePlayer(player);
 }
Exemplo n.º 18
0
        public static void HandlePitcher(List <clsPitcher> colPitchers)
        {
            PlayerBusinessLogic pBLL   = new PlayerBusinessLogic();
            PlayerDomainModel   player = new PlayerDomainModel();

            PlayerPostiionBusinessLogic ppBLL          = new PlayerPostiionBusinessLogic();
            PlayerPositionDomainModel   playerposition = new PlayerPositionDomainModel();

            StatBusinessLogic sBLL = new StatBusinessLogic();
            StatDomainModel   stat = new StatDomainModel();

            SeasonPlayerPositionStatBusinessLogic sppsBLL   = new SeasonPlayerPositionStatBusinessLogic();
            SeasonPlayerPositionStatDomainModel   statValue = new SeasonPlayerPositionStatDomainModel();

            SeasonPlayerBusinessLogic spBLL = new SeasonPlayerBusinessLogic();
            SeasonPlayerDomainModel   spDM  = new SeasonPlayerDomainModel();


            statValue.SeasonID   = C_SeasonID;
            statValue.PlayerGUID = player.PlayerGUID;
            sppsBLL.DeleteAllStatsForPlayer(statValue);

            foreach (clsPitcher cPitcher in colPitchers)
            {
                player.PlayerName = cPitcher.FirstName.Trim() + " " + cPitcher.LastName.Trim();
                pBLL.InsertPlayer(player);

                playerposition.PlayerGUID          = player.PlayerGUID;
                playerposition.PrimaryPositionID   = TransformPos(cPitcher.Pos);
                playerposition.SecondaryPostiionID = null;
                ppBLL.DeletePlayerPosition(playerposition);
                ppBLL.InsertPlayerPosition(playerposition);

                spDM.PlayerGUID = player.PlayerGUID;
                spDM.SeasonID   = C_SeasonID;
                spBLL.InsertSeasonPlayer(spDM);

                BindingFlags flags = BindingFlags.Instance |
                                     BindingFlags.Public | BindingFlags.NonPublic;


                foreach (FieldInfo f in cPitcher.GetType().GetFields(flags))
                {
                    Console.WriteLine("{0} = {1}", f.Name, f.GetValue(cPitcher));
                    System.Diagnostics.Debug.WriteLine("{0} = {1}", f.Name, f.GetValue(cPitcher));
                    string fieldName = _getBackingFieldName(f.Name.ToUpper());


                    if (fieldName != "FIRSTNAME" &&
                        fieldName != "LASTNAME" &&
                        fieldName != "PT" &&
                        fieldName != "POS")
                    {
                        stat.StatName       = fieldName;
                        stat.PositionTypeID = 2;    // 1 = hitter
                        stat = sBLL.InsertStat(stat);

                        statValue.SeasonID   = C_SeasonID;
                        statValue.PlayerGUID = player.PlayerGUID;
                        statValue.PositionID = TransformPos(cPitcher.Pos);
                        statValue.StatID     = stat.StatID;
                        if (f.GetValue(cPitcher) == null)
                        {
                            statValue.StatValue = null;
                        }
                        else
                        {
                            statValue.StatValue = f.GetValue(cPitcher).ToString();
                        }

                        sppsBLL.InsertStatValue(statValue);
                    }
                }
            }
        }
 public List <v_Stat_Hitter_ViewDomainModel> GetStats(PlayerDomainModel player)
 {
     return(dal.GetStats(player));
 }