public void Delete(Address deleteThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@Id", deleteThis.Id.ToString());
_sqlToExecute = "DELETE FROM [dbo].[Address] WHERE Id = " + _dataEngine.GetParametersForQuery();
if (!_dataEngine.ExecuteSql(_sqlToExecute))
throw new Exception("Address - Delete failed");
}
public void CreateCustomer(ref Customer customer, ref Address address)
{
//Save the customer record
var insertedRowId = _da.Value.Customer.Insert(customer);
if (insertedRowId == 0)
{
throw new Exception("Failed to create customer record");
}
else
{
customer.Id = insertedRowId;
}
//Save the address record
if (address.Id == 0)
{
//Create a new address record
insertedRowId = _da.Value.Address.Insert(address);
if (insertedRowId == 0)
{
throw new Exception("Failed to create address record");
}
else
{
address.Id = insertedRowId;
}
}
//Link the customer and address records
var customerAddressLink = new LinkObjectMaster()
{
MasterLinkId = customer.Id,
MasterLinkType = LinkType.Customer,
ChildLinkId = address.Id,
ChildLinkType = LinkType.Address
};
//Save the link record
insertedRowId = _da.Value.Link.Insert(customerAddressLink);
if (insertedRowId == 0)
{
//Roll back the inserts as it's failed
//Delete the customer record
_da.Value.Customer.Delete(customer);
//Delete the address record
_da.Value.Address.Delete(address);
throw new Exception("Failed to create customer address link record, transaction rolled back");
}
}
public int Insert(Address saveThis)
{
try
{
_db.Addresses.InsertOnSubmit(saveThis);
_db.SubmitChanges();
return saveThis.Id;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public void Delete(Address deleteThis)
{
try
{
if (deleteThis.Id > 0)
{
_db.Addresses.DeleteOnSubmit(deleteThis);
_db.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public void Update(Address updateThis)
{
try
{
_db.Addresses.Attach(updateThis);
_db.Refresh(RefreshMode.KeepCurrentValues, updateThis);
_db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public int Insert(Address saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@Address1", saveThis.Address1);
_dataEngine.AddParameter("@Address2", saveThis.Address2);
_dataEngine.AddParameter("@Address3", saveThis.Address3);
_dataEngine.AddParameter("@Town", saveThis.Town);
_dataEngine.AddParameter("@County", saveThis.County);
_dataEngine.AddParameter("@Country", saveThis.Country);
_dataEngine.AddParameter("@AddressOther", saveThis.AddressOther);
_dataEngine.AddParameter("@PostCode", saveThis.PostCode);
_sqlToExecute = "INSERT INTO [dbo].[Address] ";
_sqlToExecute += "([Address1]";
_sqlToExecute += ",[Address2]";
_sqlToExecute += ",[Address3]";
_sqlToExecute += ",[Town]";
_sqlToExecute += ",[County]";
_sqlToExecute += ",[Country]";
_sqlToExecute += ",[AddressOther]";
_sqlToExecute += ",[PostCode]) ";
_sqlToExecute += "OUTPUT INSERTED.Id ";
_sqlToExecute += "VALUES ";
_sqlToExecute += "(";
_sqlToExecute += _dataEngine.GetParametersForQuery();
_sqlToExecute += ")";
int insertedRowId = 0;
if (!_dataEngine.ExecuteSql(_sqlToExecute, out insertedRowId))
throw new Exception("Address - Save failed");
return insertedRowId;
}
/// <summary>
/// Creates the object from the data returned from the database
/// </summary>
/// <returns></returns>
private Address CreateAddressFromData()
{
var address = new Address
{
Address1 = _dataEngine.Dr["Address1"].ToString(),
Address2 = _dataEngine.Dr["Address2"].ToString(),
Address3 = _dataEngine.Dr["Address3"].ToString(),
Town = _dataEngine.Dr["Town"].ToString(),
County = _dataEngine.Dr["County"].ToString(),
Country = _dataEngine.Dr["Country"].ToString(),
AddressOther = _dataEngine.Dr["AddressOther"].ToString(),
PostCode = _dataEngine.Dr["PostCode"].ToString(),
Id = int.Parse(_dataEngine.Dr["Id"].ToString())
};
return address;
}
public void Update(Address saveThis)
{
_dataEngine.InitialiseParameterList();
_dataEngine.AddParameter("@Address1", saveThis.Address1);
_dataEngine.AddParameter("@Address2", saveThis.Address2);
_dataEngine.AddParameter("@Address3", saveThis.Address3);
_dataEngine.AddParameter("@Town", saveThis.Town);
_dataEngine.AddParameter("@County", saveThis.County);
_dataEngine.AddParameter("@Country", saveThis.Country);
_dataEngine.AddParameter("@AddressOther", saveThis.AddressOther);
_dataEngine.AddParameter("@PostCode", saveThis.PostCode);
_sqlToExecute = "UPDATE [dbo].[Address] SET ";
_sqlToExecute += "[Address1] = @Address1";
_sqlToExecute += ",[Address2] = @Address2";
_sqlToExecute += ",[Address3] = @Address3";
_sqlToExecute += ",[Town] = @Town";
_sqlToExecute += ",[County] = @County";
_sqlToExecute += ",[Country] = @Country";
_sqlToExecute += ",[AddressOther] = @AddressOther";
_sqlToExecute += ",[PostCode] = PostCode ";
_sqlToExecute += "WHERE [Id] = " + saveThis.Id;
if (!_dataEngine.ExecuteSql(_sqlToExecute))
throw new Exception("Address - Update failed");
}
public void CreateLocation(int customerId, ref Location location, ref Address address)
{
//Check a valid customer id has been passed
try
{
var customer = _da.Value.Customer.GetById(customerId);
}
catch (Exception ex)
{
throw ex;
}
//Create a new location record
var insertedRowId = _da.Value.Location.Insert(location);
if (insertedRowId == 0)
{
throw new Exception("Failed to create location record");
}
else
{
location.Id = insertedRowId;
}
//Link the customer and location
var customerLocationLink = new LinkObjectMaster()
{
MasterLinkId = customerId,
MasterLinkType = LinkType.Customer,
ChildLinkId = location.Id,
ChildLinkType = LinkType.Location
};
//Save the link record
insertedRowId = _da.Value.Link.Insert(customerLocationLink);
if (insertedRowId == 0)
{
//Roll back the inserts as it's failed
//Delete the location record
_da.Value.Location.Delete(location);
throw new Exception("Failed to create customer location link record, transaction rolled back");
}
//Save the address record
var addressCreated = false;
if (address.Id == 0)
{
//Create a new address record
insertedRowId = _da.Value.Address.Insert(address);
if (insertedRowId == 0)
{
throw new Exception("Failed to create address record");
}
else
{
address.Id = insertedRowId;
addressCreated = true;
}
}
//Link the location and address records
var locationAddressLink = new LinkObjectMaster()
{
MasterLinkId = location.Id,
MasterLinkType = LinkType.Location,
ChildLinkId = address.Id,
ChildLinkType = LinkType.Address
};
//Save the link record
insertedRowId = _da.Value.Link.Insert(locationAddressLink);
if (insertedRowId == 0)
{
//Roll back the inserts as it's failed
//Delete the location record
_da.Value.Location.Delete(location);
if (addressCreated)
_da.Value.Address.Delete(address);
throw new Exception("Failed to create location address link record, transaction rolled back");
}
}