/// <summary>
/// Deletes indicators and associated records from IUS and IC_IUS table
/// </summary>
/// <param name="indicatorNids"></param>
public void DeleteIndicator(string indicatorNids)
{
DITables TableNames;
IUSBuilder IUSBuilder;
MetaDataBuilder MetadataBuilderObject;
string AssocicatedIUSNIds = string.Empty;
try
{
IUSBuilder = new IUSBuilder(this.DBConnection, this.DBQueries);
// Step 1: Delete records from Indicator table
foreach (DataRow Row in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
{
TableNames = new DITables(this.DBQueries.DataPrefix, "_" + Row[Language.LanguageCode].ToString());
this.DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.Indicator.Delete.DeleteIndicator(TableNames.Indicator, indicatorNids));
}
// Step 2: Delete records from IUS table
// Step2(a): Get all associated IUSNIds
AssocicatedIUSNIds = IUSBuilder.GetAllAssociatedIUSNids(indicatorNids, string.Empty, string.Empty);
// Step2(b): Delete all associated IUSNIds
IUSBuilder.DeleteIUS(AssocicatedIUSNIds);
// delete metadata
MetadataBuilderObject = new MetaDataBuilder(this.DBConnection, this.DBQueries);
MetadataBuilderObject.DeleteMetadata(indicatorNids, MetadataElementType.Indicator);
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
}
/// <summary>
/// Deletes units and associated records from IUS a IC_IUS table table
/// </summary>
/// <param name="nids"></param>
public void DeleteUnit(string nids)
{
DITables TableNames;
IUSBuilder IUSBuilder;
string AssocicatedIUSNIds = string.Empty;
try
{
IUSBuilder = new IUSBuilder(this.DBConnection, this.DBQueries);
// Step 1: Delete records from Unit table
foreach (DataRow Row in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
{
TableNames = new DITables(this.DBQueries.DataPrefix, "_" + Row[Language.LanguageCode].ToString());
this.DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.Unit.Delete.DeleteUnits(TableNames.Unit, nids));
}
// Step 2: Delete records from IUS table
// Step2(a): Get all associated IUSNIds
AssocicatedIUSNIds = IUSBuilder.GetAllAssociatedIUSNids(string.Empty, nids, string.Empty);
// Step2(b): Delete all associated IUSNIds
IUSBuilder.DeleteIUS(AssocicatedIUSNIds);
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
}
/// <summary>
/// Deletes indicators and associated records from IUS and IC_IUS table
/// </summary>
/// <param name="indicatorNids"></param>
public void DeleteIndicator(string indicatorNids)
{
DITables TableNames;
IUSBuilder IUSBuilder;
MetaDataBuilder MetadataBuilderObject;
string AssocicatedIUSNIds = string.Empty;
try
{
IUSBuilder = new IUSBuilder(this.DBConnection, this.DBQueries);
// Step 1: Delete records from Indicator table
foreach (DataRow Row in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
{
TableNames = new DITables(this.DBQueries.DataPrefix, "_" + Row[Language.LanguageCode].ToString());
this.DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.Indicator.Delete.DeleteIndicator(TableNames.Indicator, indicatorNids));
}
// Step 2: Delete records from IUS table
// Step2(a): Get all associated IUSNIds
AssocicatedIUSNIds = IUSBuilder.GetAllAssociatedIUSNids(indicatorNids, string.Empty, string.Empty);
// Step2(b): Delete all associated IUSNIds
IUSBuilder.DeleteIUS(AssocicatedIUSNIds);
// delete metadata
MetadataBuilderObject = new MetaDataBuilder(this.DBConnection, this.DBQueries);
MetadataBuilderObject.DeleteMetadata(indicatorNids, MetadataElementType.Indicator);
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
}
