private void UpdateInfo()
{
signcollection sc = new signcollection
{
collectionId = mySignCollection.collectionId,
password = txt_password.Text,
name = txt_collectionName.Text,
contactPerson = txt_contactPerson.Text,
contactPersonEmail = txt_contactPersonEmail.Text,
contactPersonTel = txt_contactPersonTel.Text,
contactPersonTitle = txt_contactPersonTitle.Text
};
db.UpdateSignCollection(sc);
organisation org = new organisation
{
id = myOrganisation.id,
name = txt_organisation.Text,
email = txt_orgEmail.Text,
address = txt_address.Text,
tel = txt_orgTel.Text
};
db.UpdateOrganisation(org);
mySignCollection = db.GetSignCollection(mySignCollection.collectionId);
mySigns = db.GetSigns(mySignCollection.collectionId);
myOrganisation = db.GetOrganisation(mySignCollection.organisationId);
this.SetForm();
}
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 FrmCollectionDetails(FrmHomepage parent, String collectionId)
{
InitializeComponent();
this.parent = parent;
tableLayoutPanel2.SetColumnSpan(txt_address, 3);
db = new SignChatDB();
mySignCollection = db.GetSignCollection(collectionId);
mySigns = db.GetSigns(collectionId);
myOrganisation = db.GetOrganisation(mySignCollection.organisationId);
SetForm();
editMode = false;
}
public FrmOrganisationDetails(FrmHomepage parent, int organisationId) : this(parent)
{
myOrganisation = db.GetOrganisation(organisationId);
signcollectionsList = db.GetCollectionList(organisationId);
SetData();
}