public Hashtable GetAllOffice() { Hashtable retData = new Hashtable(); string query = @"SELECT [ID], [BranchID], [Name], [UpdateBy], [UpdateTime] FROM [Office]"; DataSet dataSet = DataAccess.ExecuteQuery(query); if ((dataSet != null) && (dataSet.Tables.Count > 0) && (dataSet.Tables[0].Rows.Count > 0)) { for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { Office office = new Office(dataSet.Tables[0].Rows[i][0].ToString()); string branchID = null; if (dataSet.Tables[0].Rows[i][1] != DBNull.Value) { branchID = dataSet.Tables[0].Rows[i][1].ToString(); office.Branch = new Branch(branchID); } else { office.Branch = null; } office.Name = dataSet.Tables[0].Rows[i][2].ToString(); if (dataSet.Tables[0].Rows[i][3] != DBNull.Value) { office.UpdateBy = dataSet.Tables[0].Rows[i][3].ToString(); } else { office.UpdateBy = null; } if (dataSet.Tables[0].Rows[i][4] != DBNull.Value) { office.UpdateTime = (DateTime)dataSet.Tables[0].Rows[i][4]; } else { office.UpdateTime = DateTime.MaxValue; } retData[office.Id] = office; } } return retData; }
public Hashtable GetAllBroker() { Hashtable retData = new Hashtable(); string query = @"SELECT a.[ID], a.[BrokerTypeID], a.[OfficeID], a.[SupervisorBrokerID], b.[Name] as SupervisorName, a.[Name], a.[EntranceDate], a.[LeaveDate], a.[IsActive], a.[UpdateBy], a.[UpdateTime], a.[Email], a.[AECommissionCode],a.[SUPCommissionCode],a.[MANCommissionCode], c.AdjustRate , a.[SupporterID] FROM [Broker] a left outer join [Broker] b on a.SupervisorBrokerID = b.ID left outer join [BrokerRate] c on a.ID = c.BrokerID WHERE a.IsActive = 1"; DataSet dataSet = DataAccess.ExecuteQuery(query); if ((dataSet != null) && (dataSet.Tables.Count > 0) && (dataSet.Tables[0].Rows.Count > 0)) { for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { Broker broker = new Broker(dataSet.Tables[0].Rows[i][0].ToString()); // Broker Type broker.BrokerTypeId = dataSet.Tables[0].Rows[i][1].ToString(); // Office if (dataSet.Tables[0].Rows[i][2] != DBNull.Value) { // Dummy office to hold the OfficeID string officeID = dataSet.Tables[0].Rows[i][2].ToString(); Office office = new Office(officeID); broker.Office = office; } if (dataSet.Tables[0].Rows[i][3] != DBNull.Value) { // Dummy broker to store only Supervisor Broker ID Broker supervisor = new Broker(dataSet.Tables[0].Rows[i][3].ToString()); broker.Supervisor = supervisor; } broker.Name = dataSet.Tables[0].Rows[i][5].ToString(); broker.IsActive = true; if (dataSet.Tables[0].Rows[i][12] != DBNull.Value) { broker.AECommissionCode = dataSet.Tables[0].Rows[i][12].ToString().Trim(); } if (dataSet.Tables[0].Rows[i][13] != DBNull.Value) { broker.SUPCommissionCode = dataSet.Tables[0].Rows[i][13].ToString().Trim(); } if (dataSet.Tables[0].Rows[i][14] != DBNull.Value) { broker.MANCommissionCode = dataSet.Tables[0].Rows[i][14].ToString().Trim(); } if (dataSet.Tables[0].Rows[i][15] != DBNull.Value) { broker.AdjustRate = new BrokerRate(broker); broker.AdjustRate.AdjustRate = (double)dataSet.Tables[0].Rows[i][15]; } if (dataSet.Tables[0].Rows[i][16] != DBNull.Value) { // Dummy broker to store only Supporter Broker ID Broker supporter = new Broker(dataSet.Tables[0].Rows[i][16].ToString()); broker.Supporter = supporter; } else { broker.AdjustRate = null; } retData[broker.Id] = broker; } // Re iterate the broker list to link to the real supervisor objects (instead of dummies which only store the id) for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { string brokerID = dataSet.Tables[0].Rows[i][0].ToString(); Broker broker = (Broker)retData[brokerID]; if ((broker != null) && (broker.Supervisor != null)) { Broker supervisor = (Broker)retData[broker.Supervisor.Id]; if (supervisor != null) { //broker.Supervisor = supervisor; broker.JoinGroup(supervisor); } else { broker.Supervisor = null; } } } } return retData; }
public OfficeCalculationResult(Office office) { this.Office = office; }