Exemplo n.º 1
0
        /// <summary>
        /// 更新一条记录(异步方式)
        /// </summary>
        /// <param name="entity">实体模型</param>
        /// <returns></returns>
        public virtual async Task <bool> UpdateAsync(CardsEntity entity)
        {
            Dictionary <string, object> dict = new Dictionary <string, object>();

            GetParameters(entity, dict);
            string strSQL = "Update Cards SET " +
                            "CardType = @CardType," +
                            "ProductID = @ProductID," +
                            "TableName = @TableName," +
                            "CardNum = @CardNum," +
                            "Password = @Password," +
                            "AgentName = @AgentName," +
                            "Money = @Money," +
                            "ValidNum = @ValidNum," +
                            "ValidUnit = @ValidUnit," +
                            "EndDate = @EndDate," +
                            "UserName = @UserName," +
                            "UseTime = @UseTime," +
                            "CreateTime = @CreateTime," +
                            "OrderItemID = @OrderItemID," +
                            "ProductName = @ProductName" +
                            " WHERE " +

                            "CardID = @CardID";

            return(await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)));
        }
Exemplo n.º 2
0
        private void NewMatchAddCard(int matchNum)
        {
            if (!string.IsNullOrWhiteSpace(tbCardTitle.Text) &&
                cbxLocation.SelectedItem != null
                )
            {
                string brandName = cbxBrandName.SelectedItem.ToString();

                //Why are we saving this? FOR SCIENCE~! (And also because this will help us draw the correct matches for this card to populate the LV)
                CardsEntity thisCard = new CardsEntity()
                {
                    CardID      = idHelper.CurrentID(false, true, false, false, false, false, false),
                    CardName    = tbCardTitle.Text,
                    ConnOrgName = OrgName,
                    BrandName   = brandName,
                    Location    = cbxLocation.SelectedItem.ToString()
                };

                cHelper.SaveCardsList(thisCard);

                AddMatch add = new AddMatch(tbCardTitle.Text, OrgName, brandName, matchNum);
                add.Show();
                this.Hide();
            }
            else
            {
                tbCardTitle.BackColor = Color.MistyRose;
                cbxLocation.BackColor = Color.MistyRose;
            }
        }
Exemplo n.º 3
0
        public FinalizeCard(int cardID)
        {
            InitializeComponent();

            currMatchCount = 0;

            thisCard = cHelper.PopulateCardsList().FirstOrDefault(c => c.CardID == cardID);

            storeHelper.WrestlersList = wHelper.PopulateWrestlersList().Where(w => w.CurrentCompanyName == thisCard.ConnOrgName).ToList();
            storeHelper.MatchesList   = mHelper.PopulateMatchesList().Where(m => m.AttachedCardName == thisCard.CardName).ToList();


            if (storeHelper.MatchesList.Count == 1 ||
                storeHelper.MatchesList.Count < 1
                )
            {
                btnFwd.Enabled   = false;
                btnBckwd.Enabled = false;
            }
            else
            {
                btnFwd.Enabled   = true;
                btnBckwd.Enabled = true;
            }

            PopulateNextMatch(storeHelper.MatchesList[0]);
        }
Exemplo n.º 4
0
        private void PopulateFields(CardsEntity card, MatchesEntity match)
        {
            MatchesEntity currMatch = match;

            lblCardTitle.Text    = card.CardName;
            lblCardSubTitle.Text = card.SubTitle;

            lblMatchNum.Text   = currMatch.CardMatchNumber.ToString();
            lblMatchTitle.Text = currMatch.MatchTitle;
            lblMatchRules.Text = currMatch.MatchType + "/" + currMatch.MatchRules;
            lblChamp.Text      = currMatch.Title;

            lblPart1.Text = currMatch.Participant1;
            lblPart2.Text = currMatch.Participant2;
            lblPart3.Text = currMatch.Participant3;
            lblPart4.Text = currMatch.Participant4;
            lblPart5.Text = currMatch.Participant5;
            lblPart6.Text = currMatch.Participant6;
            lblPart7.Text = currMatch.Participant7;
            lblPart8.Text = currMatch.Participant8;


            lblMatchRating.Text = currMatch.MatchRating.ToString();

            lblMatchRating.Enabled = true;
        }
Exemplo n.º 5
0
        private string ButtonOutput(CardsEntity card)
        {
            string output = "";

            output = card.ConnOrgName + " - " + card.CardName + " : " + card.FinalCardRating;

            return(output);
        }
Exemplo n.º 6
0
        public FinalRating(int cardID)
        {
            InitializeComponent();

            thisCard = cHelper.PopulateCardsList().FirstOrDefault(c => c.CardID == cardID);

            storeHelper.MatchesList = mHelper.PopulateMatchesList().Where(m => m.AttachedCardName == thisCard.CardName).ToList();

            PopulateFields(thisCard, storeHelper.MatchesList);
        }
Exemplo n.º 7
0
        private void PopulateFields(CardsEntity card, List <MatchesEntity> matches)
        {
            card.FinalCardRating = FinalCardRating(matches);

            lblOrgName.Text   = card.ConnOrgName;
            lblBrandName.Text = card.BrandName;

            lblCardTitle.Text    = card.CardName;
            lblCardSubTitle.Text = card.SubTitle;

            lblTotalMatches.Text = matches.Count().ToString();
            lblFinalRating.Text  = card.FinalCardRating.ToString();
        }
Exemplo n.º 8
0
        /// <summary>
        /// 获取实体
        /// </summary>
        /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
        /// <param name="dict">参数的名/值集合</param>
        /// <returns></returns>
        public virtual CardsEntity GetEntity(string strWhere, Dictionary <string, object> dict = null)
        {
            CardsEntity obj    = null;
            string      strSQL = "select top 1 * from Cards where 1=1 " + strWhere;

            using (NullableDataReader reader = _DB.GetDataReader(strSQL, dict))
            {
                if (reader.Read())
                {
                    obj = GetEntityFromrdr(reader);
                }
            }
            return(obj);
        }
Exemplo n.º 9
0
        /// <summary>
        /// 获取实体(异步方式)
        /// </summary>
        /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
        /// <param name="dict">参数的名/值集合</param>
        /// <returns></returns>
        public virtual async Task <CardsEntity> GetEntityAsync(string strWhere, Dictionary <string, object> dict = null)
        {
            CardsEntity obj    = null;
            string      strSQL = "select top 1 * from Cards where 1=1 " + strWhere;

            using (NullableDataReader reader = await Task.Run(() => _DB.GetDataReader(strSQL, dict)))
            {
                if (reader.Read())
                {
                    obj = GetEntityFromrdr(reader);
                }
            }
            return(obj);
        }
Exemplo n.º 10
0
        public AddMatch(string cardName, string orgName, string brandName, int matchNum)
        {
            InitializeComponent();

            CardName  = cardName;
            BrandName = brandName;
            OrgName   = orgName;
            MatchNum  = matchNum;

            storeHelper.WrestlersList = wHelper.PopulateWrestlersList().Where(w => w.CurrentCompanyName == OrgName).ToList();
            storeHelper.TeamsList     = tHelper.PopulateTeamsList().Where(t => t.OrgName == OrgName).ToList();
            storeHelper.TitlesList    = tiHelper.PopulateTitlesList().Where(ti => ti.OwnerOrgName == OrgName).ToList();

            thisCard = cHelper.PopulateCardsList().FirstOrDefault(c => c.CardName == CardName);
            storeHelper.MatchesList = mHelper.PopulateMatchesList().Where(m => m.AttachedCardName == thisCard.CardName).ToList();
        }
Exemplo n.º 11
0
        private void button1_Click(object sender, EventArgs e)
        {
            CardsEntity card = new CardsEntity()
            {
                CardName    = tbCardTitle.Text,
                Location    = cbxLocation.SelectedItem.ToString(),
                ConnOrgName = OrgName
            };

            CardHelper cHelper = new CardHelper();

            cHelper.SaveCardsList(card);

            FinalizeCard finalize = new FinalizeCard(card.CardID);

            finalize.Show();
            this.Hide();
        }
Exemplo n.º 12
0
 /// <summary>
 /// 把实体类转换成键/值对集合
 /// </summary>
 /// <param name="entity"></param>
 /// <param name="dict"></param>
 private static void GetParameters(CardsEntity entity, Dictionary <string, object> dict)
 {
     dict.Add("CardID", entity.CardID);
     dict.Add("CardType", entity.CardType);
     dict.Add("ProductID", entity.ProductID);
     dict.Add("TableName", entity.TableName);
     dict.Add("CardNum", entity.CardNum);
     dict.Add("Password", entity.Password);
     dict.Add("AgentName", entity.AgentName);
     dict.Add("Money", entity.Money);
     dict.Add("ValidNum", entity.ValidNum);
     dict.Add("ValidUnit", entity.ValidUnit);
     dict.Add("EndDate", entity.EndDate);
     dict.Add("UserName", entity.UserName);
     dict.Add("UseTime", entity.UseTime);
     dict.Add("CreateTime", entity.CreateTime);
     dict.Add("OrderItemID", entity.OrderItemID);
     dict.Add("ProductName", entity.ProductName);
 }
Exemplo n.º 13
0
        public PastCardsMain(CardsEntity card)
        {
            InitializeComponent();

            CardName = card.CardName;
            OrgName  = card.ConnOrgName;

            PromotionsEntity promo = pHelper.PopulatePromotionsList().FirstOrDefault(p => p.Name == OrgName);

            CardsEntity c = cHelper.PopulateCardsList().FirstOrDefault(ca => ca.CardName == CardName && ca.ConnOrgName == promo.Name);

            lblPromoName.Text    = promo.Name;
            lblCardLocation.Text = card.Location;

            lblCardTitle.Text    = card.CardName;
            lblCardSubTitle.Text = card.SubTitle;

            lblTotalMatches.Text = card.NumOfMatches.ToString();
            lblFinalRating.Text  = card.FinalCardRating.ToString();
        }
Exemplo n.º 14
0
        /// <summary>
        /// 增加一条记录
        /// </summary>
        /// <param name="entity">实体模型</param>
        /// <returns></returns>
        public virtual bool Add(CardsEntity entity)
        {
            Dictionary <string, object> dict = new Dictionary <string, object>();

            GetParameters(entity, dict);

            string strSQL = "insert into Cards (" +
                            "CardType," +
                            "ProductID," +
                            "TableName," +
                            "CardNum," +
                            "Password," +
                            "AgentName," +
                            "Money," +
                            "ValidNum," +
                            "ValidUnit," +
                            "EndDate," +
                            "UserName," +
                            "UseTime," +
                            "CreateTime," +
                            "OrderItemID," +
                            "ProductName) " +
                            "values(" +
                            "@CardType," +
                            "@ProductID," +
                            "@TableName," +
                            "@CardNum," +
                            "@Password," +
                            "@AgentName," +
                            "@Money," +
                            "@ValidNum," +
                            "@ValidUnit," +
                            "@EndDate," +
                            "@UserName," +
                            "@UseTime," +
                            "@CreateTime," +
                            "@OrderItemID," +
                            "@ProductName)";

            return(_DB.ExeSQLResult(strSQL, dict));
        }
Exemplo n.º 15
0
        /// <summary>
        /// 增加一条记录,返回新的ID号。需要有一个单一主键,并且开启有标识符属性(异步方式)
        /// </summary>
        /// <param name="entity">实体模型</param>
        /// <returns></returns>
        public virtual async Task <int> InsertAsync(CardsEntity entity)
        {
            Dictionary <string, object> dict = new Dictionary <string, object>();

            GetParameters(entity, dict);

            string strSQL = "insert into Cards (" +
                            "CardType," +
                            "ProductID," +
                            "TableName," +
                            "CardNum," +
                            "Password," +
                            "AgentName," +
                            "Money," +
                            "ValidNum," +
                            "ValidUnit," +
                            "EndDate," +
                            "UserName," +
                            "UseTime," +
                            "CreateTime," +
                            "OrderItemID," +
                            "ProductName) " +
                            "values(" +
                            "@CardType," +
                            "@ProductID," +
                            "@TableName," +
                            "@CardNum," +
                            "@Password," +
                            "@AgentName," +
                            "@Money," +
                            "@ValidNum," +
                            "@ValidUnit," +
                            "@EndDate," +
                            "@UserName," +
                            "@UseTime," +
                            "@CreateTime," +
                            "@OrderItemID," +
                            "@ProductName)";

            return(await Task.Run(() => _DB.ReturnID(strSQL, dict)));
        }
Exemplo n.º 16
0
        public void SaveCardsList(CardsEntity card)
        {
            FileStream   stream = new FileStream(Directory.GetCurrentDirectory() + "\\Saves\\Main\\Cards\\" + card.CardID + ".dat", FileMode.Create, FileAccess.Write);
            StreamWriter writer = new StreamWriter(stream);

            writer.WriteLine(card.CardID);

            writer.WriteLine(card.CardName);
            writer.WriteLine(card.SubTitle);
            writer.WriteLine(card.Location);
            writer.WriteLine(card.BrandName);

            writer.WriteLine(card.ConnOrgName);

            writer.WriteLine(card.NumOfMatches);

            writer.WriteLine(card.FinalCardRating);

            writer.Close();
            stream.Close();
        }
Exemplo n.º 17
0
        private void button1_Click(object sender, EventArgs e)
        {
            IDSetterHelper idHelper = new IDSetterHelper();

            CardsEntity newCard = new CardsEntity()
            {
                CardID          = idHelper.CurrentID(false, true, false, false, false, false, false),
                CardName        = lblCardTitle.Text,
                SubTitle        = lblCardSubTitle.Text,
                ConnOrgName     = lblOrgName.Text,
                BrandName       = lblBrandName.Text,
                NumOfMatches    = Convert.ToInt32(lblTotalMatches.Text),
                FinalCardRating = Convert.ToInt32(lblFinalRating.Text)
            };

            cHelper.SaveCardsList(newCard);

            ContinueMain main = new ContinueMain();

            main.Show();
            this.Hide();
        }
Exemplo n.º 18
0
        /// <summary>
        /// 通过数据读取器生成实体类
        /// </summary>
        /// <param name="rdr"></param>
        /// <returns></returns>
        private static CardsEntity GetEntityFromrdr(NullableDataReader rdr)
        {
            CardsEntity info = new CardsEntity();

            info.CardID      = rdr.GetInt32("CardID");
            info.CardType    = rdr.GetInt32("CardType");
            info.ProductID   = rdr.GetInt32("ProductID");
            info.TableName   = rdr.GetString("TableName");
            info.CardNum     = rdr.GetString("CardNum");
            info.Password    = rdr.GetString("Password");
            info.AgentName   = rdr.GetString("AgentName");
            info.Money       = rdr.GetDecimal("Money");
            info.ValidNum    = rdr.GetInt32("ValidNum");
            info.ValidUnit   = rdr.GetInt32("ValidUnit");
            info.EndDate     = rdr.GetNullableDateTime("EndDate");
            info.UserName    = rdr.GetString("UserName");
            info.UseTime     = rdr.GetNullableDateTime("UseTime");
            info.CreateTime  = rdr.GetNullableDateTime("CreateTime");
            info.OrderItemID = rdr.GetInt32("OrderItemID");
            info.ProductName = rdr.GetString("ProductName");
            return(info);
        }
Exemplo n.º 19
0
        public FinalizeOutput(int cardID)
        {
            InitializeComponent();

            currMatchCount = 0;

            thisCard = cHelper.PopulateCardsList().FirstOrDefault(c => c.CardID == cardID);

            storeHelper.MatchesList = mHelper.PopulateMatchesList().Where(m => m.AttachedCardName == thisCard.CardName).ToList();

            if (storeHelper.MatchesList.Count == 1)
            {
                btnFwd.Enabled = false;
                btnBck.Enabled = false;
            }
            else
            {
                btnFwd.Enabled = true;
                btnBck.Enabled = true;
            }

            PopulateFields(thisCard, storeHelper.MatchesList[currMatchCount]);
        }
Exemplo n.º 20
0
        public List <CardsEntity> PopulateCardsList()
        {
            List <CardsEntity> cardList = new List <CardsEntity>();

            string dir = string.Concat(Directory.GetCurrentDirectory(), "\\Saves\\Main\\Cards");

            if (!Directory.Exists(dir))
            {
                Directory.CreateDirectory(string.Concat(Directory.GetCurrentDirectory(), "\\Saves\\Main\\Cards"));
            }
            else
            {
                FileInfo[] files = (new DirectoryInfo(dir).GetFiles("*.dat"));

                if (files.Length > 0)
                {
                    for (int i = 0; i < files.Length; i++)
                    {
                        try
                        {
                            FileInfo info = files[i];

                            using (StreamReader reader = new StreamReader(info.FullName))
                            {
                                CardsEntity card = new CardsEntity();

                                string id = reader.ReadLine();
                                card.CardID = Convert.ToInt32(id);

                                card.CardName  = reader.ReadLine();
                                card.SubTitle  = reader.ReadLine();
                                card.Location  = reader.ReadLine();
                                card.BrandName = reader.ReadLine();

                                card.ConnOrgName = reader.ReadLine();

                                string matchesNum = reader.ReadLine();
                                card.NumOfMatches = Convert.ToInt32(matchesNum);

                                string finalRating = reader.ReadLine();
                                card.FinalCardRating = Convert.ToInt32(finalRating);

                                cardList.Add(card);

                                reader.Close();
                                //stream.Close();
                            }
                        }
                        catch (Exception e)
                        {
                            dir = string.Concat(Directory.GetCurrentDirectory(), "\\Logs");

                            if (!Directory.Exists(dir))
                            {
                                Directory.CreateDirectory(string.Concat(Directory.GetCurrentDirectory(), "\\Logs"));
                            }

                            string log = "Log - " + DateTime.Today.Ticks.ToString();

                            FileStream   stream = new FileStream(Directory.GetCurrentDirectory() + "\\Logs\\" + log + ".dat", FileMode.Create, FileAccess.Write);
                            StreamWriter writer = new StreamWriter(stream);

                            string err = e.ToString();
                            writer.WriteLine(err + "\n");

                            writer.Close();
                            stream.Close();
                        }
                    }
                }
            }

            return(cardList);
        }
Exemplo n.º 21
0
        public PastMatchMain(MatchesEntity match)
        {
            InitializeComponent();

            MatchName = match.Title;
            CardName  = match.AttachedCardName;

            storeHelper.CardsList   = cHelper.PopulateCardsList();
            storeHelper.MatchesList = mHelper.PopulateMatchesList();

            MatchesEntity ma   = storeHelper.MatchesList.FirstOrDefault(m => m.Title == MatchName && m.AttachedCardName == CardName);
            CardsEntity   card = storeHelper.CardsList.FirstOrDefault(c => c.CardName == CardName && c.CardName == match.AttachedCardName);

            lblCardPromo.Text = card.ConnOrgName;
            lblCardLoc.Text   = card.Location;

            lblCardTitle.Text = card.CardName;
            lblSubTitle.Text  = card.SubTitle;

            lblMatchTitle.Text = match.Title;

            lblRedRes.Text = match.RedSideResult;
            lblPart1.Text  = match.Participant1;
            lblPart3.Text  = match.Participant3;
            lblPart5.Text  = match.Participant5;
            lblPart7.Text  = match.Participant7;

            switch (match.RedSideResult)
            {
            case "Won":
                lblRedRes.BackColor = Color.Green;
                lblRedRes.ForeColor = Color.PaleGreen;
                break;

            case "Draw":
                lblRedRes.BackColor = Color.DarkGoldenrod;
                lblRedRes.ForeColor = Color.NavajoWhite;
                break;

            case "Loss":
                lblRedRes.BackColor = Color.Crimson;
                lblRedRes.ForeColor = Color.MistyRose;
                break;
            }

            lblBlueRes.Text = match.BlueSideResult;
            lblPart2.Text   = match.Participant2;
            lblPart4.Text   = match.Participant4;
            lblPart6.Text   = match.Participant6;
            lblPart8.Text   = match.Participant8;

            switch (match.BlueSideResult)
            {
            case "Won":
                lblBlueRes.BackColor = Color.Green;
                lblBlueRes.ForeColor = Color.PaleGreen;
                break;

            case "Draw":
                lblBlueRes.BackColor = Color.DarkGoldenrod;
                lblBlueRes.ForeColor = Color.NavajoWhite;
                break;

            case "Loss":
                lblBlueRes.BackColor = Color.Crimson;
                lblBlueRes.ForeColor = Color.MistyRose;
                break;
            }

            if (match.FinalFallCount > 0)
            {
                lblRndOrFalls.Text      = "Fall #:";
                lblMatchRndFallNum.Text = match.FinalFallCount.ToString();
            }
            else if (match.FinalNumOfRounds > 0)
            {
                lblRndOrFalls.Text      = "Round #:";
                lblMatchRndFallNum.Text = match.FinalNumOfRounds.ToString();
            }

            lblMatchRndFallMins.Text = match.FinalMatchMins.ToString();
            lblMatchRndFallSecs.Text = match.FinalMatchSecs.ToString();

            lblMatchFinalRating.Text = match.MatchRating.ToString();
        }
Exemplo n.º 22
0
 /// <summary>
 /// 增加或更新一条记录(异步方式)
 /// </summary>
 /// <param name="entity">实体模型</param>
 /// <param name="IsSave">是否增加</param>
 /// <returns></returns>
 public virtual async Task <bool> AddOrUpdateAsync(CardsEntity entity, bool IsSave)
 {
     return(IsSave ? await AddAsync(entity) : await UpdateAsync(entity));
 }
Exemplo n.º 23
0
 /// <summary>
 /// 增加或更新一条记录
 /// </summary>
 /// <param name="entity">实体模型</param>
 /// <param name="IsSave">是否增加</param>
 /// <returns></returns>
 public virtual bool AddOrUpdate(CardsEntity entity, bool IsSave)
 {
     return(IsSave ? Add(entity) : Update(entity));
 }
Exemplo n.º 24
0
        public NewCard(string orgName, bool isNewCard = true, string cardName = "", int currWrestNum = 0)
        {
            InitializeComponent();

            this.Invalidate();

            OrgName    = orgName;
            CardName   = cardName;
            bIsNewCard = isNewCard;

            if (bIsNewCard)
            {
                storeHelper.WrestlersList  = wHelper.PopulateWrestlersList();
                storeHelper.TeamsList      = tHelper.PopulateTeamsList();
                storeHelper.TitlesList     = tiHelper.PopulateTitlesList();
                storeHelper.PromotionsList = pHelper.PopulatePromotionsList();
                storeHelper.BrandsList     = bHelper.PopulateBrandsList();
                storeHelper.CardsList      = cHelper.PopulateCardsList();

                //This gets the int id of the most recent card (aka- this one)
                int currCard = storeHelper.CardsList.Count();

                PromotionsEntity promo    = storeHelper.PromotionsList.FirstOrDefault(p => p.Name == OrgName);
                CardsEntity      thisCard = storeHelper.CardsList.FirstOrDefault(c => c.ConnOrgName == promo.Name && c.CardID == currCard);

                List <MatchesEntity> cardM = storeHelper.MatchesList.Where(m => m.AttachedCardName == thisCard.CardName).ToList();

                List <BrandsEntity> brands = storeHelper.BrandsList.Where(b => b.ConnOrgName == promo.Name).ToList();

                if (brands.Count == 0)
                {
                    cbxBrandName.Items.Add("");
                    cbxBrandName.SelectedIndex = 0;
                }
                else
                {
                    cbxBrandName.Items.Add("");
                    foreach (BrandsEntity b in brands)
                    {
                        cbxBrandName.Items.Add(b.Name);
                    }

                    cbxBrandName.SelectedIndex = 0;
                }

                button1.Enabled = false;
            }
            else
            {
                storeHelper.CardsList = cHelper.PopulateCardsList();

                //This gets the int id of the most recent card (aka- this one)
                int currCard = storeHelper.CardsList.Count();

                storeHelper.MatchesList    = mHelper.PopulateMatchesList();
                storeHelper.PromotionsList = pHelper.PopulatePromotionsList();
                storeHelper.BrandsList     = bHelper.PopulateBrandsList();

                PromotionsEntity    promo    = storeHelper.PromotionsList.FirstOrDefault(p => p.Name == OrgName);
                List <BrandsEntity> brands   = storeHelper.BrandsList.Where(b => b.ConnOrgName == promo.Name).ToList();
                CardsEntity         thisCard = storeHelper.CardsList.FirstOrDefault(c => c.ConnOrgName == promo.Name && c.CardID == currCard);

                List <MatchesEntity> cardM = storeHelper.MatchesList.Where(m => m.AttachedCardName == thisCard.CardName).ToList();

                if (brands.Count == 0)
                {
                    cbxBrandName.Items.Add("");
                    cbxBrandName.SelectedItem = "";
                }
                else
                {
                    cbxBrandName.Items.Add("");
                    foreach (BrandsEntity b in brands)
                    {
                        cbxBrandName.Items.Add(b.Name);
                    }
                }

                tbCardTitle.Text     = thisCard.CardName;
                tbCardTitle.Enabled  = false;
                cbxLocation.Text     = thisCard.Location;
                cbxLocation.Enabled  = false;
                cbxBrandName.Text    = thisCard.BrandName;
                cbxBrandName.Enabled = false;


                switch (cardM.Count)
                {
                case 1:
                    btnMatch1.Enabled = true;

                    btnMatch1.Text       = ButtonTextOutput(cardM, 0);
                    btnMatch1Clr.Enabled = true;

                    btnMatch2.Enabled = true;
                    break;

                case 2:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    break;

                case 3:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;
                    btnMatch4.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    break;

                case 4:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;
                    btnMatch4.Enabled = true;
                    btnMatch5.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text = ButtonTextOutput(cardM, 3);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    btnMatch4Clr.Enabled = true;
                    break;

                case 5:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;
                    btnMatch4.Enabled = true;
                    btnMatch5.Enabled = true;
                    btnMatch6.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text = ButtonTextOutput(cardM, 4);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    btnMatch4Clr.Enabled = true;
                    btnMatch5Clr.Enabled = true;
                    break;

                case 6:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;
                    btnMatch4.Enabled = true;
                    btnMatch5.Enabled = true;
                    btnMatch6.Enabled = true;
                    btnMatch7.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text = ButtonTextOutput(cardM, 5);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    btnMatch4Clr.Enabled = true;
                    btnMatch5Clr.Enabled = true;
                    btnMatch6Clr.Enabled = true;
                    break;

                case 7:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;
                    btnMatch4.Enabled = true;
                    btnMatch5.Enabled = true;
                    btnMatch6.Enabled = true;
                    btnMatch7.Enabled = true;
                    btnMatch8.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text = ButtonTextOutput(cardM, 5);
                    btnMatch7.Text = ButtonTextOutput(cardM, 6);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    btnMatch4Clr.Enabled = true;
                    btnMatch5Clr.Enabled = true;
                    btnMatch6Clr.Enabled = true;
                    btnMatch7Clr.Enabled = true;
                    break;

                case 8:
                    btnMatch1.Enabled = true;
                    btnMatch2.Enabled = true;
                    btnMatch3.Enabled = true;
                    btnMatch4.Enabled = true;
                    btnMatch5.Enabled = true;
                    btnMatch6.Enabled = true;
                    btnMatch7.Enabled = true;
                    btnMatch8.Enabled = true;
                    btnMatch9.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text = ButtonTextOutput(cardM, 5);
                    btnMatch7.Text = ButtonTextOutput(cardM, 6);
                    btnMatch8.Text = ButtonTextOutput(cardM, 7);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    btnMatch4Clr.Enabled = true;
                    btnMatch5Clr.Enabled = true;
                    btnMatch6Clr.Enabled = true;
                    btnMatch7Clr.Enabled = true;
                    btnMatch8Clr.Enabled = true;
                    break;

                case 9:
                    btnMatch1.Enabled  = true;
                    btnMatch2.Enabled  = true;
                    btnMatch3.Enabled  = true;
                    btnMatch4.Enabled  = true;
                    btnMatch5.Enabled  = true;
                    btnMatch6.Enabled  = true;
                    btnMatch7.Enabled  = true;
                    btnMatch8.Enabled  = true;
                    btnMatch9.Enabled  = true;
                    btnMatch10.Enabled = true;

                    btnMatch1.Text = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text = ButtonTextOutput(cardM, 5);
                    btnMatch7.Text = ButtonTextOutput(cardM, 6);
                    btnMatch8.Text = ButtonTextOutput(cardM, 7);
                    btnMatch9.Text = ButtonTextOutput(cardM, 8);

                    btnMatch1Clr.Enabled = true;
                    btnMatch2Clr.Enabled = true;
                    btnMatch3Clr.Enabled = true;
                    btnMatch4Clr.Enabled = true;
                    btnMatch5Clr.Enabled = true;
                    btnMatch6Clr.Enabled = true;
                    btnMatch7Clr.Enabled = true;
                    btnMatch8Clr.Enabled = true;
                    btnMatch9Clr.Enabled = true;
                    break;

                case 10:
                    btnMatch1.Enabled  = true;
                    btnMatch2.Enabled  = true;
                    btnMatch3.Enabled  = true;
                    btnMatch4.Enabled  = true;
                    btnMatch5.Enabled  = true;
                    btnMatch6.Enabled  = true;
                    btnMatch7.Enabled  = true;
                    btnMatch8.Enabled  = true;
                    btnMatch9.Enabled  = true;
                    btnMatch10.Enabled = true;
                    btnMatch11.Enabled = true;

                    btnMatch1.Text  = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text  = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text  = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text  = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text  = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text  = ButtonTextOutput(cardM, 5);
                    btnMatch7.Text  = ButtonTextOutput(cardM, 6);
                    btnMatch8.Text  = ButtonTextOutput(cardM, 7);
                    btnMatch9.Text  = ButtonTextOutput(cardM, 8);
                    btnMatch10.Text = ButtonTextOutput(cardM, 9);

                    btnMatch1Clr.Enabled  = true;
                    btnMatch2Clr.Enabled  = true;
                    btnMatch3Clr.Enabled  = true;
                    btnMatch4Clr.Enabled  = true;
                    btnMatch5Clr.Enabled  = true;
                    btnMatch6Clr.Enabled  = true;
                    btnMatch7Clr.Enabled  = true;
                    btnMatch8Clr.Enabled  = true;
                    btnMatch9Clr.Enabled  = true;
                    btnMatch10Clr.Enabled = true;
                    break;

                case 11:
                    btnMatch1.Enabled     = true;
                    btnMatch2.Enabled     = true;
                    btnMatch3.Enabled     = true;
                    btnMatch4.Enabled     = true;
                    btnMatch5.Enabled     = true;
                    btnMatch6.Enabled     = true;
                    btnMatch7.Enabled     = true;
                    btnMatch8.Enabled     = true;
                    btnMatch9.Enabled     = true;
                    btnMatch10.Enabled    = true;
                    btnMatch11.Enabled    = true;
                    btnMatch12.Enabled    = true;
                    btnMatch12Clr.Enabled = true;

                    btnMatch1.Text  = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text  = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text  = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text  = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text  = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text  = ButtonTextOutput(cardM, 5);
                    btnMatch7.Text  = ButtonTextOutput(cardM, 6);
                    btnMatch8.Text  = ButtonTextOutput(cardM, 7);
                    btnMatch9.Text  = ButtonTextOutput(cardM, 8);
                    btnMatch10.Text = ButtonTextOutput(cardM, 9);
                    btnMatch11.Text = ButtonTextOutput(cardM, 10);

                    btnMatch1Clr.Enabled  = true;
                    btnMatch2Clr.Enabled  = true;
                    btnMatch3Clr.Enabled  = true;
                    btnMatch4Clr.Enabled  = true;
                    btnMatch5Clr.Enabled  = true;
                    btnMatch6Clr.Enabled  = true;
                    btnMatch7Clr.Enabled  = true;
                    btnMatch8Clr.Enabled  = true;
                    btnMatch9Clr.Enabled  = true;
                    btnMatch10Clr.Enabled = true;
                    btnMatch11Clr.Enabled = true;
                    break;

                case 12:
                    btnMatch1.Enabled  = true;
                    btnMatch2.Enabled  = true;
                    btnMatch3.Enabled  = true;
                    btnMatch4.Enabled  = true;
                    btnMatch5.Enabled  = true;
                    btnMatch6.Enabled  = true;
                    btnMatch7.Enabled  = true;
                    btnMatch8.Enabled  = true;
                    btnMatch9.Enabled  = true;
                    btnMatch10.Enabled = true;
                    btnMatch11.Enabled = true;
                    btnMatch12.Enabled = true;

                    btnMatch1.Text  = ButtonTextOutput(cardM, 0);
                    btnMatch2.Text  = ButtonTextOutput(cardM, 1);
                    btnMatch3.Text  = ButtonTextOutput(cardM, 2);
                    btnMatch4.Text  = ButtonTextOutput(cardM, 3);
                    btnMatch5.Text  = ButtonTextOutput(cardM, 4);
                    btnMatch6.Text  = ButtonTextOutput(cardM, 5);
                    btnMatch7.Text  = ButtonTextOutput(cardM, 6);
                    btnMatch8.Text  = ButtonTextOutput(cardM, 7);
                    btnMatch9.Text  = ButtonTextOutput(cardM, 8);
                    btnMatch10.Text = ButtonTextOutput(cardM, 9);
                    btnMatch11.Text = ButtonTextOutput(cardM, 10);
                    btnMatch12.Text = ButtonTextOutput(cardM, 11);

                    btnMatch1Clr.Enabled  = true;
                    btnMatch2Clr.Enabled  = true;
                    btnMatch3Clr.Enabled  = true;
                    btnMatch4Clr.Enabled  = true;
                    btnMatch5Clr.Enabled  = true;
                    btnMatch6Clr.Enabled  = true;
                    btnMatch7Clr.Enabled  = true;
                    btnMatch8Clr.Enabled  = true;
                    btnMatch9Clr.Enabled  = true;
                    btnMatch10Clr.Enabled = true;
                    btnMatch11Clr.Enabled = true;
                    btnMatch12Clr.Enabled = true;
                    break;

                default:
                    btnMatch1.Enabled  = true;
                    btnMatch2.Enabled  = false;
                    btnMatch3.Enabled  = false;
                    btnMatch4.Enabled  = false;
                    btnMatch5.Enabled  = false;
                    btnMatch6.Enabled  = false;
                    btnMatch7.Enabled  = false;
                    btnMatch8.Enabled  = false;
                    btnMatch9.Enabled  = false;
                    btnMatch10.Enabled = false;
                    btnMatch11.Enabled = false;
                    btnMatch12.Enabled = false;

                    btnMatch1Clr.Enabled  = false;
                    btnMatch2Clr.Enabled  = false;
                    btnMatch3Clr.Enabled  = false;
                    btnMatch4Clr.Enabled  = false;
                    btnMatch5Clr.Enabled  = false;
                    btnMatch6Clr.Enabled  = false;
                    btnMatch7Clr.Enabled  = false;
                    btnMatch8Clr.Enabled  = false;
                    btnMatch9Clr.Enabled  = false;
                    btnMatch10Clr.Enabled = false;
                    btnMatch11Clr.Enabled = false;
                    btnMatch12Clr.Enabled = false;
                    break;
                }

                button1.Enabled = true;
            }
        }