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();
}
public signcollection GetSignCollection(String collectionId)
{
using (database content = new database())
{
signcollection collection = content.signcollection.Where(i => i.collectionId == collectionId).FirstOrDefault();
return(collection);
}
}
public void NewCollection(signcollection clt)
{
using (database content = new database())
{
content.signcollection.Add(clt);
content.SaveChanges();
}
}
private void FrmCollectionDetails_VisibleChanged(object sender, EventArgs e)
{
// if change for invisible to visible
if (!isVisible && this.Visible && !editMode)
{
mySignCollection = db.GetSignCollection(mySignCollection.collectionId);
mySigns = db.GetSigns(mySignCollection.collectionId);
myOrganisation = db.GetOrganisation(mySignCollection.organisationId);
textBox1.Text = "";
SetForm();
}
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;
}
private void FrmOrganisationDetails_VisibleChanged(object sender, EventArgs e)
{
// if change for invisible to visible
if (!isVisible && this.Visible)
{
myOrganisation = db.GetOrganisation(myOrganisation.id);
signcollectionsList = db.GetCollectionList(myOrganisation.id);
txt_organisation.Text = myOrganisation.name;
txt_orgId.Text = myOrganisation.id.ToString();
txt_orgEmail.Text = myOrganisation.email;
txt_orgTel.Text = myOrganisation.tel;
txt_address.Text = myOrganisation.address;
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;
}
int signNum = db.GetNoOfSign(sc.collectionId);
int datasetNum = db.GetNoOfDataset(sc.collectionId);
row.Cells[1].Value = sc.name;
row.Cells[2].Value = signNum;
row.Cells[3].Value = datasetNum;
row.Cells[4].Value = sc.contactPerson;
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, signNum, datasetNum, sc.contactPerson);
}
}
}
isVisible = this.Visible;
}
public void UpdateSignCollection(signcollection sc)
{
using (database content = new database())
{
signcollection ori = content.signcollection.FirstOrDefault(i => i.collectionId == sc.collectionId);
if (ori != null)
{
ori.password = sc.password;
ori.name = sc.name;
ori.contactPerson = sc.contactPerson;
ori.contactPersonEmail = sc.contactPersonEmail;
ori.contactPersonTel = sc.contactPersonTel;
ori.contactPersonTitle = sc.contactPersonTitle;
content.SaveChanges();
}
}
}
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;
}
private void Button2_Click(object sender, EventArgs e)
{
if (!ValidateForm())
{
return;
}
// New sign collection
signcollection sc = new signcollection
{
collectionId = txt_collectionId.Text,
password = txt_password.Text,
name = txt_collectionName.Text,
contactPerson = txt_contactPerson.Text,
contactPersonEmail = txt_contactPersonEmail.Text,
contactPersonTel = txt_contactPersonTel.Text,
contactPersonTitle = txt_contactPersonTitle.Text,
organisationId = organisations.ElementAt(cbBox_organisation.SelectedIndex).id
};
// New organisation
if (ckBox_newOrg.Checked)
{
organisation org = new organisation
{
name = txt_organisation.Text,
email = txt_orgEmail.Text,
address = txt_address.Text,
tel = txt_orgTel.Text
};
sc.organisationId = db.NewOrganisation(org);
}
db.NewCollection(sc);
// Change page
FrmCollectionDetails frm = new FrmCollectionDetails(parent, sc.collectionId);
parent.ReplaceWith(frm);
}
private bool ValidateForm()
{
bool validate = true;
List <Control> requiredControls = new List <Control>();
requiredControls.Add(txt_collectionId);
requiredControls.Add(txt_collectionName);
requiredControls.Add(txt_password);
requiredControls.Add(txt_orgEmail);
requiredControls.Add(txt_orgTel);
requiredControls.Add(txt_address);
requiredControls.Add(txt_contactPerson);
foreach (Control c in requiredControls)
{
if (c.Text == "")
{
errorProvider.SetError(c, "Required.");
errorProvider.SetIconPadding(c, -20);
validate = false;
}
else
{
errorProvider.SetError(c, "");
}
}
if (txt_collectionId.Text != "")
{
signcollection sc = db.GetSignCollection(txt_collectionId.Text);
if (sc != null)
{
errorProvider.SetError(txt_collectionId, "Collection ID is in used.");
errorProvider.SetIconPadding(txt_collectionId, -20);
validate = false;
}
else
{
errorProvider.SetError(txt_collectionId, "");
}
}
if (ckBox_newOrg.Checked && txt_organisation.Text == "")
{
errorProvider.SetError(txt_organisation, "Required.");
errorProvider.SetIconPadding(txt_organisation, -20);
validate = false;
}
else if (!ckBox_newOrg.Checked && cbBox_organisation.SelectedIndex < 0)
{
errorProvider.SetError(cbBox_organisation, "Required.");
errorProvider.SetIconPadding(cbBox_organisation, -20);
validate = false;
}
else
{
errorProvider.SetError(txt_organisation, "");
errorProvider.SetError(cbBox_organisation, "");
}
if (txt_contactPersonEmail.Text == "" && txt_contactPersonTel.Text == "")
{
errorProvider.SetError(txt_contactPersonEmail, "Please enter at least one of the contact method.");
errorProvider.SetIconPadding(txt_contactPersonEmail, -20);
errorProvider.SetError(txt_contactPersonTel, "Please enter at least one of the contact method.");
errorProvider.SetIconPadding(txt_contactPersonTel, -20);
validate = false;
}
else
{
errorProvider.SetError(txt_contactPersonEmail, "");
errorProvider.SetError(txt_contactPersonTel, "");
}
return(validate);
}
