public void Move_Change_Log_Transactions(string group_record) { List <SQLParam> parms = new List <SQLParam>(); parms.Add(SQLParam.GetParam("@group_record", group_record)); _stageProvider.ExecuteNonQuery("SYNC_Move_EtlChangeLog_Stage", parms); }
private bool Keyword_Map_Subscriber_Resident() { bool isMapped = true; try { _sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@locdef", _locationDef)); this._sqlParms.Add(SQLParam.GetParam("@resdef", _residentDef)); this._sqlParms.Add(SQLParam.GetParam("@subscriber", "-1")); _Subscriber_ID = _stageProvider.ExecuteScalar <string>("SYNC_Map_Subscriber_Resident", _sqlParms); if (_Subscriber_ID == "-1") { isMapped = false; } } catch (Exception ex) { this.EntityMessage(string.Format("Keyword_Map_Subscriber_Resident error: {0} on resident_def {1}.", ex.Message, _residentDef.ToString()), "ERROR"); isMapped = false; } //this.EntityMessage(string.Format("Keyword_Map_Subscriber_Resident is_mapped: {0} on resident_def {1}.", isMapped.ToString(), _residentDef.ToString())); return(isMapped); }
bool Map_Subscriber() { bool isMapped = true; try { _sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@locdef", this._locationDef)); this._sqlParms.Add(SQLParam.GetParam("@resdef", this._residentDef)); this._sqlParms.Add(SQLParam.GetParam("@subscriber", "-1")); _Subscriber_ID = _stageProvider.ExecuteScalar <string>("SYNC_Map_Subscriber_Resident", _sqlParms); if (_Subscriber_ID != "-1") { this.EntityMessage(string.Format("Subscriber Id {0} found for call_def {1}", this._Subscriber_ID, this._call_def), "INFO"); } else { this.EntityMessage(string.Format("No Subscriber Id found for call_def {0}", this._call_def), "INFO"); isMapped = false; } } catch (Exception ex) { isMapped = false; this.EntityMessage(string.Format("Failed to map subscriber for call_def {0}. Error: {1}", _dataToMapp["call_def"].ToString(), ex.Message), "ERROR"); } return(isMapped); }
private bool Subscriber_Medical_Info_Lookup() { bool isMapped = true; try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@subscriber_ID", _Subscriber_ID)); _sqlParms.Add(SQLParam.GetParam("@id", _Code)); _sqlParms.Add(SQLParam.GetParam("@type", _type)); _SubscriberMedicalInfo = _stageProvider.ExecuteScalar <int>("SYNC_Subscriber_Medical_Info_Lookup", _sqlParms); if (_SubscriberMedicalInfo == -1) { isMapped = false; } } catch (Exception ex) { this.EntityMessage(string.Format("Map_SubMedInfo_To_Keyword error: {0} on resident_def {1}, keyword_ref {2}.", ex.Message, _residentDef.ToString(), _keyword_ref.ToString()), "INFO"); isMapped = false; } //this.EntityMessage(string.Format("Subscriber_Medical_Info_Lookup is_mapped {0} for Subscriber_ID {1} Type {2} Code {3}.",isMapped.ToString(),_Subscriber_ID,_type,_Code)); return(isMapped); }
public void ProcessDataFlow() { bool processrelation = this.Map_Contact_Relation_Fields(); if (processrelation) { try { _sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@process_type", "PNC")); this._sqlParms.Add(SQLParam.GetParam("@subscriber", "-1")); this._sqlParms.Add(SQLParam.GetParam("@subscriber_responder", "-1")); this._sqlParms.Add(SQLParam.GetParam("@location_ref", this._locationDef.ToString())); this._sqlParms.Add(SQLParam.GetParam("@resident_ref", this._residentDef.ToString())); this._sqlParms.Add(SQLParam.GetParam("@contact_ref", this._contact_def.ToString())); this._sqlParms.Add(SQLParam.GetParam("@type_ref", this._contact_type_ref.ToString())); this._sqlParms.Add(SQLParam.GetParam("@priority", this._priority)); _stageProvider.ExecuteNonQuery("SYNC_Process_ContactRelation", _sqlParms); this.EntityMessage(string.Format("Processed contact relation for contact_def {0}, relation_def {1}", _contact_def.ToString(), _relation_def), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to process contact relation for contact_def {0}, relation_def {1}", _contact_def, _relation_def), "ERROR"); } } }
private bool Map_Responder_Contact() { string msg; bool isMatch = false; try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@contact_def", _contact_def)); // DataRow drAgency = _stageProvider.GetData("SYNC_Map_Responder_Contact", _sqlParms).Rows[0]; DataTable dtMapContact = _stageProvider.GetData("SYNC_Map_Responder_Contact", _sqlParms); if (dtMapContact.Rows.Count > 0) { DataRow dr = dtMapContact.Rows[0]; _SubscriberResponder_ID = dr["SubscriberResponder_ID"].Parse <int>(); _Subscriber_ID = dr["Subscriber_ID"].ToString(); isMatch = true; EntityMessage(string.Format("SubscriberResponder Id {0} found for contact_def {1}", _SubscriberResponder_ID.ToString(), _contact_def.ToString()), "INFO"); } else { EntityMessage(string.Format("No mapping found for contact_def {0}. Row Count: {1}", _contact_def.ToString(), dtMapContact.Rows.Count.ToString()), "INFO"); } } catch (Exception ex) { EntityMessage(string.Format("Map_Responder_Contact had a fatal error mapping contact_def {0}. ERROR: {1}", _contact_def.ToString(), ex.Message), "ERROR"); } return(isMatch); }
public override void ProcessDataDelete() { bool isMapped = true; // map the fields try { _contact_def = this._dataToMapp["contact_def"].Parse <int>(); //_contact_type_ref = this._dataToMapp["contact_type_ref"].Parse<int>(); _residentDef = this._dataToMapp["resident_ref"].Parse <int>(); } catch (Exception ex) { this.EntityMessage(string.Format("Failed to map contact_def {0} in Contact.ProcessDataDelete. ERROR: {1}", _contact_def.ToString(), ex.Message), "ERROR"); isMapped = false; } if (isMapped) { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@contact_def", _contact_def)); _sqlParms.Add(SQLParam.GetParam("@resident_def", _residentDef)); _stageProvider.ExecuteNonQuery("SYNC_Process_Responder_Delete", _sqlParms); this.EntityMessage(string.Format("Processed responder delete for contact_def {0}", _contact_def), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to process responder delete for contact_def: {0}. ERROR: {1}", _contact_def.ToString(), ex.Message), "ERROR"); } } }
private string PNC_EPEC_MAP() { string processType = "INSERT"; try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@locdef", _locationDef)); _sqlParms.Add(SQLParam.GetParam("@resdef", _residentDef)); _sqlParms.Add(SQLParam.GetParam("@subscriber", "-1")); //_Subscriber_ID = _stageProvider.ExecuteScalar<string>("SYNC_Map_Subscriber_Location", _sqlParms); DataRow dr = _stageProvider.ExecuteDataSet("SYNC_Map_Subscriber_Location", _sqlParms).Tables[0].Rows[0]; _Subscriber_ID = dr["Subscriber_ID"].ToString(); _MasterReference = dr["MasterReference"].ToString(); if (_Subscriber_ID != "-1") { processType = "UPDATE"; EntityMessage(string.Format("Subscriber Id {0} found for location_def {1}", _Subscriber_ID, _locationDef.ToString()), "INFO"); } else { processType = "INSERT"; EntityMessage(string.Format("No Subscriber Id found for location_def {0}", _locationDef.ToString()), "INFO"); } } catch (Exception ex) { processType = "NONE"; EntityMessage(string.Format("Failed to map subsciber to location for location_def {0}. Error: {1}", _locationDef.ToString(), ex.Message), "ERROR"); } return(processType); }
public void Update_Sync_Step(string step_name) { try { List <SQLParam> parms = new List <SQLParam>(); parms.Add(SQLParam.GetParam("@step_name", step_name)); _stageProvider.ExecuteNonQuery("SYNC_Update_Sync_Step", parms); } catch { } }
public void Log_Service_Message(string log_type, string message) { try { List <SQLParam> parms = new List <SQLParam>(); parms.Add(SQLParam.GetParam("@service_name", "Kshema_PNC_Sync")); parms.Add(SQLParam.GetParam("@log_type", log_type)); parms.Add(SQLParam.GetParam("@message", message)); _stageProvider.ExecuteNonQuery("SYNC_Insert_Sync_Log", parms); } catch { } }
protected void LogServiceMessage(string serviceName, string log_type, string message) { try { List <SQLParam> parms = new List <SQLParam>(); parms.Add(SQLParam.GetParam("@service_name", serviceName)); parms.Add(SQLParam.GetParam("@log_type", log_type)); parms.Add(SQLParam.GetParam("@message", message)); _stageProvider.ExecuteNonQuery("SYNC_Insert_Sync_Log", parms); } catch { } }
private void Save_Subscriber_Language(string command) { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@subscriberId", _Subscriber_ID)); _sqlParms.Add(SQLParam.GetParam("@type", _type)); _sqlParms.Add(SQLParam.GetParam("@code", _Code)); _sqlParms.Add(SQLParam.GetParam("@command", command)); _stageProvider.ExecuteNonQuery("SYNC_Save_SubscriberLanguage", _sqlParms); } catch { } }
public void Save_Transaction_Record(string group_record, string entity, string transaction, string err_message) { try { List <SQLParam> parms = new List <SQLParam>(); parms.Add(SQLParam.GetParam("@group_record", group_record)); parms.Add(SQLParam.GetParam("@entity", entity)); parms.Add(SQLParam.GetParam("@transaction", transaction)); parms.Add(SQLParam.GetParam("@err_message", err_message)); _stageProvider.ExecuteNonQuery("SYNC_Insert_Transaction_Log", parms); } catch { } }
protected void LogServiceMessage(string log_type, string message) { try { Console.WriteLine(string.Format("{0} {1}", DateTime.Now.ToString("MM-dd-yyyy HH:mm:ss"), message)); List <SQLParam> parms = new List <SQLParam>(); parms.Add(SQLParam.GetParam("@service_name", "Agency_Import")); parms.Add(SQLParam.GetParam("@log_type", log_type)); parms.Add(SQLParam.GetParam("@message", message)); _stageProvider.ExecuteNonQuery("SYNC_Insert_Sync_Log", parms); } catch { } }
private void Delete_Resident_Directions() { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@entity_ref", _script_entity_ref)); _stageProvider.ExecuteNonQuery("SYNC_Delete_Resident_Directions", _sqlParms); this.EntityMessage(string.Format("Deleted resident direction for resident_def {0}", _script_entity_ref), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to delete resident direction for resident_def: {0}. ERROR: {1}", _script_entity_ref.ToString(), ex.Message), "ERROR"); } }
private void _Process_Delete_Resonder_Contact_Note() { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@entity_ref", _entity_ref)); _stageProvider.ExecuteNonQuery("SYNC_Delete_ResponderContact_Note", _sqlParms); this.EntityMessage(string.Format("Processed responder/contact note for note_def {0}", _entity_ref.ToString()), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to delete responder/contact notes for note_def: {0}, entity_type: {1}. ERROR: {2}", _entity_ref.ToString(), _entity_type.ToString(), ex.Message), "ERROR"); } }
private void Process_Resident_Epec_Directions() { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@note_entity", _note_entity)); _sqlParms.Add(SQLParam.GetParam("@note_text", _note_text)); _stageProvider.ExecuteNonQuery("SYNC_Process_Resident_NearestIntersection", _sqlParms); this.EntityMessage(string.Format("Processed resident_epec direction for note_entity {0}", _note_entity.ToString()), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to process resident_epec direction for note_entity: {0}", _note_entity.ToString()), "ERROR"); } }
bool Can_Sync_Call_History() { bool can_sync = false; try { _sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@subscriber_id", this._Subscriber_ID)); can_sync = _stageProvider.ExecuteScalar <bool>("SYNC_Can_Sync_Call_History", _sqlParms); } catch { } return(can_sync); }
bool Subscriber_Has_Keyword() { bool has_keyword = false; try { this._sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@resident_def", this._resident_ref)); this._sqlParms.Add(SQLParam.GetParam("@keyword_def", this._keyword_def)); this._sqlParms.Add(SQLParam.GetParam("@keyword_no", this._keyword_num)); has_keyword = this._stageProvider.ExecuteScalar <bool>("SYNC_Subscriber_Has_Keyword", this._sqlParms); } catch {} return(has_keyword); }
protected bool Check_Agency_Mapping(string agency_id) { bool ismapped = false; try { this._sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@agency_id", agency_id)); ismapped = _stageProvider.ExecuteDataSet("SYNC_Is_Mapped_Agency ", this._sqlParms).Tables[0].Rows[0]["Is_Mapped"].Parse <bool>(); } catch (Exception ex) { EntityMessage(string.Format("Fatal exception in Check_Agency_Mapping for agency {0}. Error: {1}", agency_id, ex.Message), "ERROR"); } return(ismapped); }
private void Insert_Keyword_To_Queue() { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@subscriber_ID", _Subscriber_ID)); _sqlParms.Add(SQLParam.GetParam("@Id", _Code)); _sqlParms.Add(SQLParam.GetParam("@type", _type)); _stageProvider.ExecuteNonQuery("SYNC_Insert_Keyword_SSIS_Q", _sqlParms); this.EntityMessage(string.Format("Insert_Keyword_To_Queue successfully inserted Type {0} Code {1} for Subscriber_Id {2}", _type, _Code, _Subscriber_ID), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Insert_Keyword_To_Queue failed to insert Type {0} Code {1} for Subscriber_ID {2}. ERROR: {3}", _type, _Code, _Subscriber_ID, ex.Message), "ERROR"); } }
private void Process_Responder_Contact_Note() { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@notes_def", _notes_def)); _sqlParms.Add(SQLParam.GetParam("@note_entity", _note_entity)); _sqlParms.Add(SQLParam.GetParam("@entity_type", _entity_type)); _sqlParms.Add(SQLParam.GetParam("@note_title", _note_title)); _sqlParms.Add(SQLParam.GetParam("@note_text", _note_text)); _stageProvider.ExecuteNonQuery("SYNC_Process_Responder_Note", _sqlParms); this.EntityMessage(string.Format("Processed responder note for note_def {0}", _notes_def.ToString()), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to process responder notes for note_def: {0}, entity_type: {1}, note_entity: {2}", _notes_def.ToString(), _entity_type.ToString(), _note_entity.ToString()), "ERROR"); } }
public void Fetch(string subscriber) { try { this._sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@subscriber", subscriber)); DataRow drMapping = _stageProvider.ExecuteDataSet("SYNC_Get_Subscriber_Mapping", this._sqlParms).Tables[0].Rows[0]; _location_def = drMapping["Location_Ref"].Parse <int>(); _resident_def = drMapping["Resident_Def"].Parse <int>(); _authority_ref = drMapping["Authority_Ref"].Parse <int>(); _equip_id = drMapping["Equip_Id"].Parse <long>(); _subscriber = subscriber; } catch (Exception ex) { this.EntityMessage(string.Format("Failed to fetch the subscriber mapping for {0}", subscriber), "ERROR"); } }
private bool Map_Resident_Characteristic() { bool isMatch = false; try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@attr_choice_def", _attr_choice_def)); _Status = _stageProvider.ExecuteScalar <string>("SYNC_Map_Resident_Status", _sqlParms); isMatch = true; } catch (Exception ex) { EntityMessage(string.Format("Failed to map resident status for resident_def {0}. Error: {1}", _residentDef.ToString(), ex.Message), "ERROR"); } return(isMatch); }
protected bool IsSubscriberMapped(string subscriberId) { bool isMapped = false; try { this._sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@subscriber_id", subscriberId)); DataTable dtMapping = this._stageProvider.ExecuteDataSet("SYNC_Get_Subscriber_Mapping", this._sqlParms).Tables[0]; if (dtMapping.Rows.Count >= 1) { isMapped = true; } } catch { } return(isMapped); }
private void Process_Doctor_Note() { int hospitalid = this.Parse_Hospital_Id(); if (hospitalid != -1) { try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@note_entity", _note_entity)); _sqlParms.Add(SQLParam.GetParam("@note_title", _note_title)); _sqlParms.Add(SQLParam.GetParam("@note_text", _note_text)); _stageProvider.ExecuteNonQuery("SYNC_Process_Doctor_Note ", _sqlParms); this.EntityMessage(string.Format("Processed doctor note for note_def {0}", _notes_def.ToString()), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("Unable to process doctor note for note_def: {0}, entity_type: {1}, note_entity: {2}", _notes_def.ToString(), _entity_type.ToString(), _note_entity.ToString()), "ERROR"); } } }
private bool Map_Resident_SubscriberId() { bool isMatch = false; try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@subscriber", -1)); _sqlParms.Add(SQLParam.GetParam("@locdef", _locationDef)); _sqlParms.Add(SQLParam.GetParam("@resdef", _residentDef)); _Subscriber_ID = _stageProvider.ExecuteScalar <string>("SYNC_Map_Subscriber_Resident", _sqlParms); isMatch = true; } catch (Exception ex) { EntityMessage(string.Format("Map_Resident_SubscriberId had a fatal error. ERROR: {0}", ex.Message), "ERROR"); } return(isMatch); }
private void Insert_Temp_Repsonder_Q() { string msg = string.Empty; try { if (_Subscriber_ID != "-1") { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@subscriber_id", _Subscriber_ID)); _sqlParms.Add(SQLParam.GetParam("@responder_name", _responder_name)); _sqlParms.Add(SQLParam.GetParam("@work_phone", _work_phone)); _sqlParms.Add(SQLParam.GetParam("@cell_phone", _cell_phone)); _sqlParms.Add(SQLParam.GetParam("@home_phone", _home_phone)); _sqlParms.Add(SQLParam.GetParam("@has_key", _hasKey == false ? "N" : "Y")); _sqlParms.Add(SQLParam.GetParam("@nvi_order", _NVIOrder)); _sqlParms.Add(SQLParam.GetParam("@nvi", _NVI == false ? "N" : "Y")); _sqlParms.Add(SQLParam.GetParam("@relation_type", _type)); _sqlParms.Add(SQLParam.GetParam("@relation_code", _Code)); _sqlParms.Add(SQLParam.GetParam("@contact_def", _contact_def)); _sqlParms.Add(SQLParam.GetParam("@contact_type_def", _contact_type_ref)); _sqlParms.Add(SQLParam.GetParam("@priority", _priority)); _sqlParms.Add(SQLParam.GetParam("@location_def", _locationDef)); _sqlParms.Add(SQLParam.GetParam("@resident_def", _residentDef)); _sqlParms.Add(SQLParam.GetParam("@entity_type", _entity_type)); _stageProvider.ExecuteNonQuery("SYNC_Insert_Responder_Q", _sqlParms); EntityMessage(string.Format("New contact record inserted into TEMP_PNC_CONTACT_SSIS_Q. Subscriber Id: {0}", _Subscriber_ID), "INFO"); } else { throw new Exception("The process failed to map a Subscriber Id for the contact."); } } catch (Exception ex) { EntityMessage(string.Format("Failed to insert contact_def {0} for subscriber id {1} into TEMP_PNC_CONTACT_SSIS_Q. ERROR:{2}", _contact_def.ToString(), _Subscriber_ID, ex.Message), "ERROR"); } }
private bool Map_SubMedInfo_To_Keyword() { bool isMapped = true; try { _sqlParms = new List <SQLParam>(); _sqlParms.Add(SQLParam.GetParam("@keyword_ref", _keyword_ref)); DataRow drKeyword = _stageProvider.ExecuteDataSet("SYNC_Map_SubMedInfo_Keyword", _sqlParms).Tables[0].Rows[0]; _type = drKeyword["Type"].ToString(); _Code = drKeyword["Code"].ToString(); this.EntityMessage(string.Format("Map_SubMedInfo_To_Keyword found Type {0}, Code {1} for keyword_ref {2}.", _type, _Code, _keyword_ref.ToString()), "INFO"); } catch (Exception ex) { this.EntityMessage(string.Format("No mapping found for keyword_ref {0} for resident_def {1}.", _keyword_ref.ToString(), _residentDef.ToString()), "INFO"); isMapped = false; } return(isMapped); }
bool Map_Alarm_Code() { bool isMapped = true; try { _sqlParms = new List <SQLParam>(); this._sqlParms.Add(SQLParam.GetParam("@call_code", this._call_code)); this._alarm_code = _stageProvider.ExecuteDataSet("SYNC_Get_Call_Code_Mapping", _sqlParms).Tables[0].Rows[0]["Alarm_Code"].ToString(); this.EntityMessage(string.Format("Successfully mapped call_code {0} to alarm_code {1} for call_def {2}, Subscriber Id {3}.", this._call_code, this._alarm_code, this._call_def.ToString(), this._Subscriber_ID), "INFO"); } catch (Exception ex) { isMapped = false; this.EntityMessage(string.Format("Failed to map call_code {0} for call_def {1}, Subscriber Id {2}.", this._call_code, this._call_def.ToString(), this._Subscriber_ID), "INFO"); } return(isMapped); }