public FrmCollectionList(FrmHomepage parent)
        {
            InitializeComponent();

            this.parent = parent;

            db = new SignChatDB();
            signcollectionsList = db.GetCollectionList();
            UpdateList(signcollectionsList);
        }
        private void FrmCollectionList_VisibleChanged(object sender, EventArgs e)
        {
            // if change for invisible to visible
            if (!isVisible && this.Visible)
            {
                signcollectionsList = db.GetCollectionList();
                List <signcollection> temp = signcollectionsList;
                foreach (DataGridViewRow row in dgv_collection.Rows)
                {
                    signcollection sc = temp.FirstOrDefault(i => i.collectionId == row.Cells[0].Value.ToString());
                    if (sc == null)
                    {
                        dgv_collection.Rows.Remove(row);
                        continue;
                    }
                    organisation o          = db.GetOrganisation(sc.organisationId);
                    int          signNum    = db.GetNoOfSign(sc.collectionId);
                    int          datasetNum = db.GetNoOfDataset(sc.collectionId);

                    row.Cells[1].Value = sc.name;
                    row.Cells[2].Value = o.name;
                    row.Cells[3].Value = signNum;
                    row.Cells[4].Value = datasetNum;
                    temp.Remove(sc);
                }

                if (temp.Count > 0)
                {
                    foreach (signcollection sc in temp)
                    {
                        organisation o          = db.GetOrganisation(sc.organisationId);
                        int          signNum    = db.GetNoOfSign(sc.collectionId);
                        int          datasetNum = db.GetNoOfDataset(sc.collectionId);

                        dgv_collection.Rows.Add(sc.collectionId, sc.name, o.name, signNum, datasetNum);
                    }
                }
            }

            isVisible = this.Visible;
        }
 public FrmOrganisationDetails(FrmHomepage parent, int organisationId) : this(parent)
 {
     myOrganisation      = db.GetOrganisation(organisationId);
     signcollectionsList = db.GetCollectionList(organisationId);
     SetData();
 }