public void AddNewPerson(skPerson PersonObject, int AddressID)
{
if (PersonObject != null)
{
dtPerson newperson = new dtPerson
{
EbayName = PersonObject.EbayName,
Email = PersonObject.Email,
FirstName = PersonObject.FirstName,
HomePhone = PersonObject.HomePhone,
SureName = PersonObject.Surname,
WorkPhone = PersonObject.WorkPhone,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
AddressID = AddressID,
dtPerson = newperson
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
}
public void RemoveLinktoPerson(int AddressID, int PersonID)
{
dtAddressPersonRelationShip relationship = DB.dtAddressPersonRelationShips.SingleOrDefault(x => x.AddressID == AddressID && x.PersonID == PersonID);
if (relationship != null)
{
DB.dtAddressPersonRelationShips.DeleteOnSubmit(relationship);
DB.SubmitChanges();
}
}
public void AddNewAddress(skAddresses AddressObject, int ObjectID, Type ObjectType)
{
if (ObjectType.Name == "skPerson")
{
dtAddress NewAdress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
Town = AddressObject.Town,
isActive = true,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
dtAddress = NewAdress,
PersonID = ObjectID
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
else
{
dtAddress NewAdress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
Town = AddressObject.Town,
isActive = true,
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtAddresses.InsertOnSubmit(NewAdress);
DB.SubmitChanges();
dtVendor vendor = DB.dtVendors.Where(x => x.vID == ObjectID).Single();
vendor.AddresseID = DB.dtAddresses.OrderByDescending(x => x.Created).Single().aID;
DB.SubmitChanges();
}
}
public void LinkAddressToPerson(int AddressID, int PersonID)
{
if (AddressID != 0 && PersonID != 0)
{
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
AddressID = AddressID,
PersonID = PersonID
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
}
public void AddNewPerson(skPerson PersonObject, skAddresses AddressObject)
{
if (PersonObject != null)
{
dtPerson newperson = new dtPerson
{
EbayName = PersonObject.EbayName,
Email = PersonObject.Email,
FirstName = PersonObject.FirstName,
HomePhone = PersonObject.HomePhone,
SureName = PersonObject.Surname,
WorkPhone = PersonObject.WorkPhone,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtAddress newaddress = new dtAddress
{
AddressLine1 = AddressObject.AddressLine1,
AddressLine2 = AddressObject.AddressLine2,
AddressLine3 = AddressObject.AddressLine3,
Country = AddressObject.Country,
County = AddressObject.County,
PostCode = AddressObject.PostCode,
isActive = true,
Town = AddressObject.Town
};
dtAddressPersonRelationShip relationship = new dtAddressPersonRelationShip
{
dtAddress = newaddress,
dtPerson = newperson
};
DB.dtAddressPersonRelationShips.InsertOnSubmit(relationship);
DB.SubmitChanges();
}
}
