void IService1.DeleteOffice(int officeID) // DeleteOffice
{
try
{
using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
{
tblOffice officeToDelete = (from f in context.tblOffices where f.OfficeID == officeID select f).First();
context.tblOffices.Remove(officeToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
// ADD , EDIT AND DETELE OFFICE
vwOffice IService1.AddOffice(vwOffice office) // ADD OFFICE
{
try
{
using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
{
if (office.OfficeID == 0)
{ //ZA ADD
tblOffice newOffice = new tblOffice();
newOffice.OfficeName = office.OfficeName;
newOffice.City = office.City;
newOffice.Address = office.Address;
newOffice.PostalCode = office.PostalCode;
newOffice.Phone = office.Phone;
newOffice.Mobile = office.Mobile;
context.tblOffices.Add(newOffice);
context.SaveChanges();
office.OfficeID = office.OfficeID;
return(office);
}
else
{ // ZA EDIT
tblOffice officeToEdit = (from f in context.tblOffices where f.OfficeID == office.OfficeID select f).First();
officeToEdit.OfficeName = office.OfficeName;
officeToEdit.City = office.City;
officeToEdit.Address = office.Address;
officeToEdit.PostalCode = office.PostalCode;
officeToEdit.Phone = office.Phone;
officeToEdit.Mobile = office.Mobile;
//officeToEdit.OfficeID = office.OfficeID;
context.Entry(officeToEdit).State = EntityState.Modified;
context.SaveChanges();
return(office);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}