protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_RES_BLD.RES_BLD_Building.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_RES_BLD.RES_BLD_Building.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RES_BLD_BuildingID", _RES_BLD_BuildingID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_CurrentAverageRentPrice_per_sqm_RefID", _Building_CurrentAverageRentPrice_per_sqm_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "BuildingRevisionHeader_RefID", _BuildingRevisionHeader_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_BalconyPortionPercent", _Building_BalconyPortionPercent);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_Name", _Building_Name);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_DocumentationStructure_RefID", _Building_DocumentationStructure_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsContaminationSuspected", _IsContaminationSuspected);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfFloors", _Building_NumberOfFloors);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_ElevatorCoveragePercent", _Building_ElevatorCoveragePercent);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfAppartments", _Building_NumberOfAppartments);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfOccupiedAppartments", _Building_NumberOfOccupiedAppartments);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfOffices", _Building_NumberOfOffices);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfRetailUnits", _Building_NumberOfRetailUnits);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfProductionUnits", _Building_NumberOfProductionUnits);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Building_NumberOfOtherUnits", _Building_NumberOfOtherUnits);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw ex;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw ex;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_BIL.HEC_BIL_PotentialCode_2_PotentialProcedure.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_BIL.HEC_BIL_PotentialCode_2_PotentialProcedure.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AssignmentID", _AssignmentID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_BIL_PotentialCode_RefID", _HEC_BIL_PotentialCode_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_TRE_PotentialProcedure_RefID", _HEC_TRE_PotentialProcedure_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Modification_Timestamp", _Modification_Timestamp);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_LOG.LOG_ProductTrackingInstance.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_LOG.LOG_ProductTrackingInstance.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "LOG_ProductTrackingInstanceID", _LOG_ProductTrackingInstanceID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "TrackingInstanceTakenFromSourceTrackingInstance_RefID", _TrackingInstanceTakenFromSourceTrackingInstance_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "TrackingCode", _TrackingCode);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SerialNumber", _SerialNumber);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "BatchNumber", _BatchNumber);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "OwnedBy_BusinessParticipant_RefID", _OwnedBy_BusinessParticipant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_Product_RefID", _CMN_PRO_Product_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_Product_Variant_RefID", _CMN_PRO_Product_Variant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_Product_Release_RefID", _CMN_PRO_Product_Release_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ExpirationDate", _ExpirationDate);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "InitialQuantityOnTrackingInstance", _InitialQuantityOnTrackingInstance);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CurrentQuantityOnTrackingInstance", _CurrentQuantityOnTrackingInstance);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "R_ReservedQuantity", _R_ReservedQuantity);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "R_FreeQuantity", _R_FreeQuantity);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = !Status_IsAlreadySaved || Component_Name.IsDirty || Component_Description.IsDirty;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
loader.Append(Component_Name, TableName);
loader.Append(Component_Description, TableName);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_PRO.HEC_PRO_Component.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_HEC_PRO.HEC_PRO_Component.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "HEC_PRO_ComponentID", _HEC_PRO_ComponentID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GlobalPropertyMatchingID", _GlobalPropertyMatchingID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentMatterState", _ComponentMatterState);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AbsoluteCompositionValue_Unit_RefID", _AbsoluteCompositionValue_Unit_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AbsoluteCompositionValue", _AbsoluteCompositionValue);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RelativeCompositionValue_Unit_RefID", _RelativeCompositionValue_Unit_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RelativeCompositionValue", _RelativeCompositionValue);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "BreadUnitContainedAmount", _BreadUnitContainedAmount);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "EthanolContained_VolumePercentage", _EthanolContained_VolumePercentage);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentEneryValue_in_kJ", _ComponentEneryValue_in_kJ);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Component_SimpleName", _Component_SimpleName);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Component_Name", _Component_Name.DictionaryID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Component_Description", _Component_Description.DictionaryID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentDisposalSpeedStatus", _ComponentDisposalSpeedStatus);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GalenicalTypeInsidePackageStatus", _GalenicalTypeInsidePackageStatus);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ComponentExcipientStatus", _ComponentExcipientStatus);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GalenicalType_RelativeComposition", _GalenicalType_RelativeComposition);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Modification_Timestamp", _Modification_Timestamp);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw ex;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw ex;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_LOG_WRH.LOG_WRH_Shelf.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_LOG_WRH.LOG_WRH_Shelf.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "LOG_WRH_ShelfID", _LOG_WRH_ShelfID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "GlobalPropertyMatchingID", _GlobalPropertyMatchingID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Rack_RefID", _Rack_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "R_Warehouse_RefID", _R_Warehouse_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "R_Area_RefID", _R_Area_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Shelf_Name", _Shelf_Name);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CoordinateCode", _CoordinateCode);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CoordinateX", _CoordinateX);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CoordinateY", _CoordinateY);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CoordinateZ", _CoordinateZ);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ShelfCapacity_Unit_RefID", _ShelfCapacity_Unit_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ShelfCapacity_Maximum", _ShelfCapacity_Maximum);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "R_ShelfCapacity_Free", _R_ShelfCapacity_Free);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "R_ShelfCapacity_Used", _R_ShelfCapacity_Used);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "LimitShelfContent_ToOneProduct", _LimitShelfContent_ToOneProduct);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "LimitShelfContent_ToOneProductVariant", _LimitShelfContent_ToOneProductVariant);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "LimitShelfContent_ToOneProductRelease", _LimitShelfContent_ToOneProductRelease);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsShelfLocked", _IsShelfLocked);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Predefined_Product_RefID", _Predefined_Product_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Predefined_Product_Variant_RefID", _Predefined_Product_Variant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Predefined_Product_Release_RefID", _Predefined_Product_Release_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_CMN_PRO.CMN_PRO_SubscribedCatalog.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_CMN_PRO.CMN_PRO_SubscribedCatalog.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_SubscribedCatalogID", _CMN_PRO_SubscribedCatalogID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CatalogCodeITL", _CatalogCodeITL);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_Language_RefID", _SubscribedCatalog_Language_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_Currency_RefID", _SubscribedCatalog_Currency_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_Name", _SubscribedCatalog_Name);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_Description", _SubscribedCatalog_Description);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_CurrentRevision", _SubscribedCatalog_CurrentRevision);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PublishingSupplier_RefID", _PublishingSupplier_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedBy_BusinessParticipant_RefID", _SubscribedBy_BusinessParticipant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_PricelistRelease_RefID", _SubscribedCatalog_PricelistRelease_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_ValidFrom", _SubscribedCatalog_ValidFrom);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "SubscribedCatalog_ValidThrough", _SubscribedCatalog_ValidThrough);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsCatalogValid", _IsCatalogValid);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsCatalogPublic", _IsCatalogPublic);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = !Status_IsAlreadySaved || ShiftTemplate_Name.IsDirty;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
loader.Append(ShiftTemplate_Name, TableName);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_CMN_PPS.CMN_PPS_ShiftTemplate.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_CMN_PPS.CMN_PPS_ShiftTemplate.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PPS_ShiftTemplateID", _CMN_PPS_ShiftTemplateID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ShiftTemplate_ShortName", _ShiftTemplate_ShortName);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ShiftTemplate_Name", _ShiftTemplate_Name.DictionaryID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_STR_Office_RefID", _CMN_STR_Office_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_STR_Workarea_RefID", _CMN_STR_Workarea_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_STR_Workplace_RefID", _CMN_STR_Workplace_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Default_StartTime_in_sec", _Default_StartTime_in_sec);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsWorkPattern", _IsWorkPattern);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Default_AllowedBreakTimeTemplate_RefID", _Default_AllowedBreakTimeTemplate_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "DisplayColor", _DisplayColor);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw ex;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw ex;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_ORD_CUO_RFP.ORD_CUO_RFP_IssuedProposalResponse_Position.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_ORD_CUO_RFP.ORD_CUO_RFP_IssuedProposalResponse_Position.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ORD_CUO_RFP_IssuedProposalResponse_PositionID", _ORD_CUO_RFP_IssuedProposalResponse_PositionID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ProposalResponsePositionITPL", _ProposalResponsePositionITPL);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IssuedProposalResponseHeader_RefID", _IssuedProposalResponseHeader_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_Product_RefID", _CMN_PRO_Product_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_Product_Variant_RefID", _CMN_PRO_Product_Variant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_PRO_Product_Release_RefID", _CMN_PRO_Product_Release_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CreatedFrom_RequestForProposal_Position_RefID", _CreatedFrom_RequestForProposal_Position_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Quantity", _Quantity);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "TotalPrice_WithoutTax", _TotalPrice_WithoutTax);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "TotalPrice_IncludingTax", _TotalPrice_IncludingTax);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PricePerUnit_WithoutTax", _PricePerUnit_WithoutTax);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "PricePerUnit_IncludingTax", _PricePerUnit_IncludingTax);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsReplacementProduct", _IsReplacementProduct);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw;
}
return(retStatus);
}
protected FR_Base Save(DbConnection Connection, DbTransaction Transaction, string ConnectionString)
{
//Standard return type
FR_Base retStatus = new FR_Base();
bool cleanupConnection = false;
bool cleanupTransaction = false;
try
{
bool saveDictionary = false;
bool saveORMClass = !Status_IsAlreadySaved || Status_IsDirty;
//If Status Is Dirty (Meaning the data has been changed) or Status_IsAlreadySaved (Meaning the data is in the database, when loaded) just return
if (saveORMClass == false && saveDictionary == false)
{
return(FR_Base.Status_OK);
}
#region Verify/Create Connections
//Create Connection if Connection is null
if (Connection == null)
{
cleanupConnection = true;
Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString);
Connection.Open();
}
//Create Transaction if null
if (Transaction == null)
{
cleanupTransaction = true;
Transaction = Connection.BeginTransaction();
}
#endregion
#region Dictionary Management
//Save dictionary management
if (saveDictionary == true)
{
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
//Save the dictionary or update based on if it has already been saved to the database
if (Status_IsAlreadySaved)
{
loader.Update();
}
else
{
loader.Save();
}
}
#endregion
#region Command Execution
if (saveORMClass == true)
{
//Retrieve Querry
string Query = "";
if (Status_IsAlreadySaved == true)
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_CMN_BPT_STR.CMN_BPT_STR_Office_SettingsProfile.SQL.Update.sql")).ReadToEnd();
}
else
{
Query = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("CL1_CMN_BPT_STR.CMN_BPT_STR_Office_SettingsProfile.SQL.Insert.sql")).ReadToEnd();
}
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
command.CommandText = Query;
command.CommandTimeout = QueryTimeout;
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "CMN_BPT_STR_Office_SettingsProfileID", _CMN_BPT_STR_Office_SettingsProfileID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Office_RefID", _Office_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "AdulthoodAge", _AdulthoodAge);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RestWarningThreshold_Adults_in_mins", _RestWarningThreshold_Adults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RestWarningThreshold_NonAdults_in_mins", _RestWarningThreshold_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RestMinimumThresholdl_Adults_in_mins", _RestMinimumThresholdl_Adults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RestMinimumThresholdl_NonAdults_in_mins", _RestMinimumThresholdl_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkTimeWarningTreshold_Adults_in_mins", _WorkTimeWarningTreshold_Adults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkTimeWarningTreshold_NonAdults_in_mins", _WorkTimeWarningTreshold_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkTimeMaximumTreshold_Adults_in_mins", _WorkTimeMaximumTreshold_Adults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkTimeMaximumTreshold_NonAdults_in_mins", _WorkTimeMaximumTreshold_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkStartTimeWarning_NonAdults_in_mins", _WorkStartTimeWarning_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkStartTimeMinimum_NonAdults_in_mins", _WorkStartTimeMinimum_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkEndTimeWarning_NonAdults_in_mins", _WorkEndTimeWarning_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkEndTimeMaximum_NonAdults_in_mins", _WorkEndTimeMaximum_NonAdults_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorktimeBalancePeriod_in_months", _WorktimeBalancePeriod_in_months);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "WorkdayStart_in_mins", _WorkdayStart_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "RoosterGridMinimumPlanningUnit_in_mins", _RoosterGridMinimumPlanningUnit_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "MaximumPreWork_Period_in_mins", _MaximumPreWork_Period_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "MaximumPostWork_Period_in_mins", _MaximumPostWork_Period_in_mins);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Creation_Timestamp", _Creation_Timestamp);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "Tenant_RefID", _Tenant_RefID);
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "IsDeleted", _IsDeleted);
try
{
var dbChangeCount = command.ExecuteNonQuery();
Status_IsAlreadySaved = true;
Status_IsDirty = false;
}
catch (Exception ex)
{
throw ex;
}
#endregion
#region Cleanup Transaction/Connection
//If we started the transaction, we will commit it
if (cleanupTransaction && Transaction != null)
{
Transaction.Commit();
}
//If we opened the connection we will close it
if (cleanupConnection && Connection != null)
{
Connection.Close();
}
}
#endregion
}
catch (Exception ex)
{
try
{
if (cleanupTransaction == true && Transaction != null)
{
Transaction.Rollback();
}
}
catch { }
try
{
if (cleanupConnection == true && Connection != null)
{
Connection.Close();
}
}
catch { }
throw ex;
}
return(retStatus);
}