public BranchReturnValue GetBranch(Guid logonId, Guid orgId) { DsBranches dsBranchReturnValue = new DsBranches(); BranchReturnValue branchReturnValue = new BranchReturnValue(); branchReturnValue.Branch = new Branch(); //DsBranches branchReturnValue = new DsBranches(); //OrganisationReturnValue organisationReturnValue = new OrganisationReturnValue(); //dsDepartments departmentReturnValue = new dsDepartments(); //DsWorkTypes workTypeReturnValue = new DsWorkTypes(); //EarnerReturnValue earnerReturnValue = new EarnerReturnValue(); //DsPersons personReturnValue = new DsPersons(); try { // Get the logged on user from the current logons and add their // ApplicationSettings the list of concurrent sessions. Host.LoadLoggedOnUser(logonId); try { Functions.RestrictRekoopIntegrationUser(UserInformation.Instance.DbUid); switch (UserInformation.Instance.UserType) { case DataConstants.UserType.Staff: // Can do everything break; case DataConstants.UserType.Client: case DataConstants.UserType.ThirdParty: throw new Exception("Access denied"); default: throw new Exception("Access denied"); } dsBranchReturnValue = SrvBranchLookup.GetBranch(orgId); branchReturnValue.Branch.BranchArchived = dsBranchReturnValue.Tables[0].Rows[0]["BranchArchived"].ToString(); branchReturnValue.Branch.BranchCdsReg = int.Parse(dsBranchReturnValue.Tables[0].Rows[0]["BranchCdsReg"].ToString()); branchReturnValue.Branch.BranchCdsVersion = dsBranchReturnValue.Tables[0].Rows[0]["BranchCdsVersion"].ToString(); branchReturnValue.Branch.BranchCivilContractNo = dsBranchReturnValue.Tables[0].Rows[0]["BranchCivilContractNo"].ToString(); branchReturnValue.Branch.BranchCompanyName = dsBranchReturnValue.Tables[0].Rows[0]["BranchCompanyName"].ToString(); branchReturnValue.Branch.BranchCreditAccountKey = dsBranchReturnValue.Tables[0].Rows[0]["BranchCreditAccountKey"].ToString(); branchReturnValue.Branch.BranchLondonRate = dsBranchReturnValue.Tables[0].Rows[0]["BranchLondonRate"].ToString(); branchReturnValue.Branch.BranchLSCYear = dsBranchReturnValue.Tables[0].Rows[0]["BranchLSCYear"].ToString(); branchReturnValue.Branch.BranchNetId = dsBranchReturnValue.Tables[0].Rows[0]["BranchNetId"].ToString(); branchReturnValue.Branch.BranchNoVAT = dsBranchReturnValue.Tables[0].Rows[0]["BranchNoVAT"].ToString(); branchReturnValue.Branch.BranchPsiId = dsBranchReturnValue.Tables[0].Rows[0]["BranchPsiId"].ToString(); branchReturnValue.Branch.BranchRef = dsBranchReturnValue.Tables[0].Rows[0]["BranchRef"].ToString(); branchReturnValue.Branch.BranchStarsId = dsBranchReturnValue.Tables[0].Rows[0]["BranchStarsId"].ToString(); branchReturnValue.Branch.BranchSupNum1 = dsBranchReturnValue.Tables[0].Rows[0]["BranchSupNum1"].ToString(); branchReturnValue.Branch.BranchVatPeriodEnd = dsBranchReturnValue.Tables[0].Rows[0]["BranchVatPeriodEnd"].ToString(); branchReturnValue.Branch.BranchCivilUnifiedContract = dsBranchReturnValue.Tables[0].Rows[0]["BranchCivilUnifiedContract"].ToString(); } finally { // Remove the logged on user's ApplicationSettings from the // list of concurrent sessions Host.UnloadLoggedOnUser(); } } catch (System.Data.SqlClient.SqlException) { branchReturnValue.Success = false; branchReturnValue.Message = Functions.SQLErrorMessage; } catch (Exception ex) { branchReturnValue.Success = false; branchReturnValue.Message = ex.Message; } return branchReturnValue; }
public BranchReturnValue GetBranch(Guid logonId, Guid orgId) { DsBranches dsBranchReturnValue = new DsBranches(); BranchReturnValue branchReturnValue = new BranchReturnValue(); branchReturnValue.Branch = new Branch(); //DsBranches branchReturnValue = new DsBranches(); //OrganisationReturnValue organisationReturnValue = new OrganisationReturnValue(); //dsDepartments departmentReturnValue = new dsDepartments(); //DsWorkTypes workTypeReturnValue = new DsWorkTypes(); //EarnerReturnValue earnerReturnValue = new EarnerReturnValue(); //DsPersons personReturnValue = new DsPersons(); try { // Get the logged on user from the current logons and add their // ApplicationSettings the list of concurrent sessions. Host.LoadLoggedOnUser(logonId); try { Functions.RestrictRekoopIntegrationUser(UserInformation.Instance.DbUid); switch (UserInformation.Instance.UserType) { case DataConstants.UserType.Staff: // Can do everything break; case DataConstants.UserType.Client: case DataConstants.UserType.ThirdParty: throw new Exception("Access denied"); default: throw new Exception("Access denied"); } dsBranchReturnValue = SrvBranchLookup.GetBranch(orgId); branchReturnValue.Branch.BranchArchived = dsBranchReturnValue.Tables[0].Rows[0]["BranchArchived"].ToString(); branchReturnValue.Branch.BranchCdsReg = int.Parse(dsBranchReturnValue.Tables[0].Rows[0]["BranchCdsReg"].ToString()); branchReturnValue.Branch.BranchCdsVersion = dsBranchReturnValue.Tables[0].Rows[0]["BranchCdsVersion"].ToString(); branchReturnValue.Branch.BranchCivilContractNo = dsBranchReturnValue.Tables[0].Rows[0]["BranchCivilContractNo"].ToString(); branchReturnValue.Branch.BranchCompanyName = dsBranchReturnValue.Tables[0].Rows[0]["BranchCompanyName"].ToString(); branchReturnValue.Branch.BranchCreditAccountKey = dsBranchReturnValue.Tables[0].Rows[0]["BranchCreditAccountKey"].ToString(); branchReturnValue.Branch.BranchLondonRate = dsBranchReturnValue.Tables[0].Rows[0]["BranchLondonRate"].ToString(); branchReturnValue.Branch.BranchLSCYear = dsBranchReturnValue.Tables[0].Rows[0]["BranchLSCYear"].ToString(); branchReturnValue.Branch.BranchNetId = dsBranchReturnValue.Tables[0].Rows[0]["BranchNetId"].ToString(); branchReturnValue.Branch.BranchNoVAT = dsBranchReturnValue.Tables[0].Rows[0]["BranchNoVAT"].ToString(); branchReturnValue.Branch.BranchPsiId = dsBranchReturnValue.Tables[0].Rows[0]["BranchPsiId"].ToString(); branchReturnValue.Branch.BranchRef = dsBranchReturnValue.Tables[0].Rows[0]["BranchRef"].ToString(); branchReturnValue.Branch.BranchStarsId = dsBranchReturnValue.Tables[0].Rows[0]["BranchStarsId"].ToString(); branchReturnValue.Branch.BranchSupNum1 = dsBranchReturnValue.Tables[0].Rows[0]["BranchSupNum1"].ToString(); branchReturnValue.Branch.BranchVatPeriodEnd = dsBranchReturnValue.Tables[0].Rows[0]["BranchVatPeriodEnd"].ToString(); branchReturnValue.Branch.BranchCivilUnifiedContract = dsBranchReturnValue.Tables[0].Rows[0]["BranchCivilUnifiedContract"].ToString(); } finally { // Remove the logged on user's ApplicationSettings from the // list of concurrent sessions Host.UnloadLoggedOnUser(); } } catch (System.Data.SqlClient.SqlException) { branchReturnValue.Success = false; branchReturnValue.Message = Functions.SQLErrorMessage; } catch (Exception ex) { branchReturnValue.Success = false; branchReturnValue.Message = ex.Message; } return(branchReturnValue); }