public OwnersCompany updateCompany(string id, OwnersCompany comp)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
var query = (from acc in db.OWNERS_COMPANies where acc.COMP_ID.Equals(Convert.ToInt32(id)) select acc);
if (query.Count() == 1)
{
OWNERS_COMPANY acc = query.Single();
comp = new OwnersCompany()
{
ContactNum = acc.CONTACT_NUM,
Email = acc.EMAIL,
CompanyName = acc.NAME,
RegNum = acc.REG_NUM
};
db.SubmitChanges();
return(comp);
}
else
{
return(null);
}
}
}
catch (Exception)
{
return(null);
}
}
public void deleteCompany(string compId)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
OWNERS_COMPANY ToDelete = (from s in db.OWNERS_COMPANies where s.COMP_ID.Equals(Convert.ToInt32(compId)) select s).Single();
db.OWNERS_COMPANies.DeleteOnSubmit(ToDelete);
db.SubmitChanges();
}
}
catch (Exception e)
{
e.GetBaseException();
}
}
public string insertCompany(OwnersCompany comp)
{
try
{
using (HotelManagementServerDataContext db = new HotelManagementServerDataContext())
{
OWNERS_COMPANY companyLinq = ConvertToLinq.ConvertCompanyToLinq(comp);
db.OWNERS_COMPANies.InsertOnSubmit(companyLinq);
db.SubmitChanges();
return("Success Adding company was successful");
}
}
catch (Exception)
{
return("Failed Adding company failed, contact admin");
}
}
