/// <summary>
/// Save
/// </summary>
public void Save()
{
UnitsOfMeasurementAssociationsToolTDS unitsOfMeasurementAssociationsToolAddChanges = (UnitsOfMeasurementAssociationsToolTDS)Data.GetChanges();
if (unitsOfMeasurementAssociationsToolAddChanges != null)
{
if (unitsOfMeasurementAssociationsToolAddChanges.AssociatedUnits.Rows.Count > 0)
{
UnitsOfMeasurementAssociationsToolAssociatedUnitsGateway unitsOfMeasurementAssociationsToolAssociatedUnitsGateway = new UnitsOfMeasurementAssociationsToolAssociatedUnitsGateway(unitsOfMeasurementAssociationsToolAddChanges);
// Update associations
foreach (UnitsOfMeasurementAssociationsToolTDS.AssociatedUnitsRow row in (UnitsOfMeasurementAssociationsToolTDS.AssociatedUnitsDataTable)unitsOfMeasurementAssociationsToolAddChanges.AssociatedUnits)
{
int companyId = row.COMPANY_ID;
// Insert new unit of measurement
if ((row.Selected) && (!row.Deleted) && (!row.InDataBase))
{
int associationsId = row.AssociationsID;
int unitOfMeasurementId = row.UnitOfMeasurementID;
string module = row.Module;
bool byDefault = row.ByDefault;
bool deleted = row.Deleted;
UnitsOfMeasurementAssociations unitsOfMeasurementAssociations = new UnitsOfMeasurementAssociations(null);
unitsOfMeasurementAssociations.InsertDirect(associationsId, unitOfMeasurementId, module, byDefault, deleted, companyId);
}
// Update associations
if ((row.Selected) && (!row.Deleted) && (row.InDataBase))
{
int associationsId = row.AssociationsID;
int unitOfMeasurementId = row.UnitOfMeasurementID;
bool originalDeleted = false;
int originalCompanyId = companyId;
// Original values
int originalUnitOfMeasurementId = unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.GetUnitOfMeasurementIdOriginal(associationsId);
string originalModule = unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.GetModuleOriginal(associationsId);
bool originalByDefault = unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.GetByDefaultOriginal(associationsId);
// New values
int newUnitOfMeasurementId = unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.GetUnitOfMeasurementId(associationsId);
string newModule = unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.GetModule(associationsId);
bool newByDefault = unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.GetByDefault(associationsId);
UnitsOfMeasurementAssociations unitsOfMeasurementAssociations = new UnitsOfMeasurementAssociations(null);
unitsOfMeasurementAssociations.UpdateDirect(associationsId, unitOfMeasurementId, originalModule, originalByDefault, originalDeleted, originalCompanyId, associationsId, unitOfMeasurementId, newModule, newByDefault, originalDeleted, originalCompanyId);
}
// Delete associations
if ((row.Deleted) && (row.InDataBase))
{
UnitsOfMeasurementAssociations unitsOfMeasurementAssociations = new UnitsOfMeasurementAssociations(null);
unitsOfMeasurementAssociations.DeleteDirect(row.AssociationsID, row.COMPANY_ID);
}
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAll
/// </summary>
/// <param name="module">module</param>
/// <param name="companyId">companyId</param>
public void LoadAll(string module, int companyId)
{
UnitsOfMeasurementAssociationsToolAssociatedUnitsGateway unitsOfMeasurementAssociationsToolAssociatedUnitsGateway = new UnitsOfMeasurementAssociationsToolAssociatedUnitsGateway(Data);
unitsOfMeasurementAssociationsToolAssociatedUnitsGateway.LoadAll(module, companyId);
}