public void Execute(ref ClientOrganization clientOrganization) { Parameters.AddWithValue("@ParentOrganizationID", clientOrganization.ParentOrganizationID); Parameters.AddWithValue("@Name", clientOrganization.Name); Parameters.AddWithValue("@Description", clientOrganization.Description); Parameters.AddWithValue("@CampaignEnabled", clientOrganization.CampaignEnabled); Parameters.AddWithValue("@Terminated", clientOrganization.Terminated); Parameters.AddWithValue("@Contracted", clientOrganization.Contracted); Parameters.AddWithValue("@AddressID", clientOrganization.AddressID); Parameters.AddWithValue("@LoadInProgress", clientOrganization.LoadInProgress); Parameters.AddWithValue("@CommunityLastUpdate", clientOrganization.CommunityLastUpdate); Parameters.AddWithValue("@IPDataLastUpdate", clientOrganization.IPDataLastUpdate); Parameters.AddWithValue("@OPDataLastUpdate", clientOrganization.OPDataLastUpdate); Parameters.AddWithValue("@ERDataLastUpdate", clientOrganization.ERDataLastUpdate); if (string.IsNullOrEmpty(clientOrganization.CreatedBy)) { clientOrganization.CreatedBy = Environment.UserName; } Parameters.AddWithValue("@CreatedBy", clientOrganization.CreatedBy); DataTable t = ExecuteReader(); if (t.Rows.Count > 0) { clientOrganization.ClientOrganizationID = t.Rows[0].Field<int>("ClientOrganizationID"); } }
public void Execute(ref ClientOrganization clientOrganization) { // Set Audit Fields clientOrganization.UpdatedBy = Environment.UserName; clientOrganization.UpdatedDT = DateTime.Now; Parameters.AddWithValue("@AddressID", clientOrganization.AddressID); Parameters.AddWithValue("@CampaignEnabled", clientOrganization.CampaignEnabled); Parameters.AddWithValue("@ClientOrganizationID", clientOrganization.ClientOrganizationID); Parameters.AddWithValue("@CommunityLastUpdate", clientOrganization.CommunityLastUpdate); Parameters.AddWithValue("@Contracted", clientOrganization.Contracted); Parameters.AddWithValue("@Description", clientOrganization.Description); Parameters.AddWithValue("@ERDataLastUpdate", clientOrganization.ERDataLastUpdate); Parameters.AddWithValue("@IPDataLastUpdate", clientOrganization.IPDataLastUpdate); Parameters.AddWithValue("@LoadInProgress", clientOrganization.LoadInProgress); Parameters.AddWithValue("@Name", clientOrganization.Name); Parameters.AddWithValue("@OPDataLastUpdate", clientOrganization.OPDataLastUpdate); Parameters.AddWithValue("@ParentOrganizationID", clientOrganization.ParentOrganizationID); Parameters.AddWithValue("@Terminated", clientOrganization.Terminated); Parameters.AddWithValue("@UpdatedBy", clientOrganization.UpdatedBy); ExecuteReader(); }
public ClientOrganization Clone() { ClientOrganization result = new ClientOrganization(); result.ClientOrganizationID = this.ClientOrganizationID; result.ParentOrganizationID = this.ParentOrganizationID; result.Name = this.Name; result.Description = this.Description; result.CampaignEnabled = this.CampaignEnabled; result.Terminated = this.Terminated; result.Contracted = this.Contracted; result.LoadInProgress = this.LoadInProgress; result.AddressID = this.AddressID; result.CommunityLastUpdate = this.CommunityLastUpdate; result.IPDataLastUpdate = this.IPDataLastUpdate; result.OPDataLastUpdate = this.OPDataLastUpdate; result.ERDataLastUpdate = this.ERDataLastUpdate; result.CreatedDT = this.CreatedDT; result.CreatedBy = this.CreatedBy; result.UpdatedDT = this.UpdatedDT; result.UpdatedBy = this.UpdatedBy; return result; }
private void ClientOrganizationUpdate(ref ClientOrganization org) { try { spClientOrganizationUpdate proc = new spClientOrganizationUpdate(ConnectionString); proc.Execute(ref org); } catch (Exception ex) { log.Error("Error updating ClientOrganization", ex); throw; } }
private void ClientOrganizationAdd(ref ClientOrganization org) { spClientOrganizationAdd proc = new spClientOrganizationAdd(ConnectionString); proc.Execute(ref org); }
public void ClientOrganizationSave(ref ClientOrganization org) { if (org.ClientOrganizationID == 0) { ClientOrganizationAdd(ref org); } else { ClientOrganizationUpdate(ref org); } }
public void ClientOrganizationFinishImport(ref ClientOrganization org) { org.LoadInProgress = false; this.ClientOrganizationSave(ref org); }
public void ClientOrganizationBeginImport(ref ClientOrganization org) { org.LoadInProgress = true; this.ClientOrganizationSave(ref org); }
public ClientOrganization ClientOrganizationLoadByID(int clientOrganizationID) { StoredProcedure proc = new StoredProcedure("[App].[spClientOrganizationSelect]",this.ConnectionString); proc.Parameters.AddWithValue("@ClientOrganizationID", clientOrganizationID); DataTable t = proc.ExecuteReader(); if (t.Rows.Count > 0) { ClientOrganization result = new ClientOrganization(t.Rows[0]); return result; } return null; }
public ClientOrgModel(ClientOrganization org, Address address) { this.clientOrg = org; this.address = address; }
/// <summary> /// Read the values that we need from ImportedFileStatus table /// </summary> /// <param name="importedFileStatusID">ImportedFileStatus Primary Key to read.</param> private void GetFileValues(int importedFileStatusID) { var sw = new Stopwatch(); sw.Start(); try { file = SystemDataProvider.ClientDataProvider.ImportedFileStatusLoadByID(importedFileStatusID); file.ProcessStatusID = (int)ProcessStatus.Processing; SystemDataProvider.ClientDataProvider.ImportedFileStatusSave(ref file); clientOrg = SystemDataProvider.ClientDataProvider.ClientOrganizationLoadByID(file.ClientOrganizationID.Value); } catch (Exception ex) { log.Error("GetFileValues", ex); throw; } finally { sw.Stop(); log.Debug(RecordTiming(System.Reflection.MethodBase.GetCurrentMethod().Name, sw)); } }