HomeService()
{
try
{
_log = new LogHelper(AppConfigurationHelper.LogFile);
}
catch { }
_provider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.SqlAnywhere, AppConfigurationHelper.PNCConnection);
}
public static void Process_Epec_Stage_Queue()
{
IDataProvider pncStage = null;
try
{
pncStage = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
pncStage.ExecuteNonQuery("TEMP_EPEC_INSERT_SUBSCRIBER", null);
}
catch { }
if (pncStage != null)
{
pncStage = null;
}
}
public static void Delete_KS_SubscriberMedicalInfo_2()
{
IDataProvider pncStage = null;
try
{
pncStage = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
pncStage.ExecuteNonQuery("SYNC_Delete_SubscriberMedInfo2", null);
}
catch { }
if (pncStage != null)
{
pncStage = null;
}
}
public static void Process_SubscriberMedicalInfo()
{
IDataProvider pncStage = null;
try
{
pncStage = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
pncStage.ExecuteNonQuery("TEMP_KEYWORD_INSERT_SUBSCRIBERMEDICALINFO", null);
}
catch { }
if (pncStage != null)
{
pncStage = null;
}
}
public static void Update_Responder_Call_Order()
{
IDataProvider pncStage = null;
try
{
pncStage = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
pncStage.ExecuteNonQuery("SYNC_Update_Responder_Call_Order", null);
}
catch { }
if (pncStage != null)
{
pncStage = null;
}
}
public static void Delete_Duplicate_Contacts()
{
IDataProvider pnc = null;
try
{
StringBuilder sql = new StringBuilder();
pnc = DALFactory.CreateSqlProvider(DatabaseProvider_Type.SqlAnywhere, AppConfiguration.PNC_Connection);
sql.Append("with dupes(Contact_ref, relation_def,rn) as");
sql.Append(" (select Contact_ref, relation_def, rn=row_number() over (partition by RESIDENT_REF, contact_ref order by relation_def)");
sql.Append(" from CONTROLCENTRE.CONTACT_RELATION where ENTITY_TYPE = 2 AND location_ref in");
sql.Append(" (select location_ref from STANDARD.RESIDENT GROUP BY LOCATION_REF HAVING COUNT(RESIDENT_DEF) =1))");
sql.Append(" select ROW_NUMBER() OVER ( ORDER BY relation_def),Contact_ref, relation_def, rn from dupes where rn > 1");
DataTable dtDelete = pnc.ExecuteDataSetQuery(sql.ToString(), null).Tables[0];
Parallel.ForEach(dtDelete.AsEnumerable(), dr =>
{
IDataProvider tmppnc = DALFactory.CreateSqlProvider(DatabaseProvider_Type.SqlAnywhere, AppConfiguration.PNC_Connection);
try
{
StringBuilder tmpsql = new StringBuilder();
tmpsql.AppendFormat("delete from CONTROLCENTRE.CONTACT_RELATION where relation_def = {0}", dr["relation_def"].ToString());
tmppnc.ExecuteNonSPQuery(tmpsql.ToString(), null);
}
catch { }
finally
{
if (tmppnc != null)
{
tmppnc = null;
}
}
});
}
catch { }
finally
{
if (pnc != null)
{
pnc = null;
}
}
}
public static void Process_Contact_Temp_Queue()
{
//exec TEMP_CONTACT_INSERT_SUBSCRIBER_RESPONDER
IDataProvider pncStage = null;
try
{
pncStage = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
pncStage.ExecuteNonQuery("TEMP_CONTACT_INSERT_SUBSCRIBER_RESPONDER", null);
}
catch { }
if (pncStage != null)
{
pncStage = null;
}
}
public SegmentMappingRepository(string dbProvider, string strConn)
{
this._dbType = (DatabaseProvider_Type)Enum.Parse(typeof(DatabaseProvider_Type), dbProvider);
_dbProvider = DALFactory.CreateSqlProvider(_dbType, strConn);
}
public Agency_Sync(string group_record)
{
_stageProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
_group_record = group_record;
}
public ServiceRepository()
{
this._stageProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
this._pncProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.SqlAnywhere, AppConfiguration.PNC_Connection);
}
protected void InitializeProviders()
{
_stageProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
_pncProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.SqlAnywhere, AppConfiguration.PNC_Connection);
_serviceRepository = new ServiceRepository();
}
protected void InitializeProvider()
{
_pncProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.SqlAnywhere, AppConfiguration.PNC_Connection);
_stageProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection);
_pl_provider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.Kshema_Connection);
}
