public void UpdateAdministrator(administrator admin)
{
using (database content = new database())
{
administrator a = content.administrator.FirstOrDefault(i => i.username == admin.username);
a.password = admin.password;
content.SaveChanges();
}
}
public int NewOrganisation(organisation org)
{
using (database content = new database())
{
content.organisation.Add(org);
content.SaveChanges();
organisation newOrg = content.organisation.OrderByDescending(i => i.id).FirstOrDefault();
return(newOrg.id);
}
}
public List <signcollection> GetCollectionList(int organisationId)
{
using (database content = new database())
{
List <signcollection> list = content.signcollection.Where(i => i.organisationId == organisationId).Select(i => i).ToList();
foreach (signcollection c in list)
{
c.organisation = content.organisation.First(i => i.id == c.organisationId);
c.sign = content.sign.Where(i => i.collectionId == c.collectionId).Select(i => i).ToList();
}
return(list);
}
}
public void UpdateOrganisation(organisation org)
{
using (database content = new database())
{
organisation ori = content.organisation.FirstOrDefault(i => i.id == org.id);
if (ori != null)
{
ori.name = org.name;
ori.email = org.email;
ori.address = org.address;
ori.tel = org.tel;
content.SaveChanges();
}
}
}
public bool LoginValidation(String username, String password)
{
using (database content = new database())
{
administrator admin = content.administrator.Where(i => i.username == username && i.password == password).FirstOrDefault();
if (admin == null)
{
return(false);
}
else
{
return(true);
}
}
}
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();
}
}
}
