コード例 #1
0
        private static AssignmentDetailsCollection  Populate(DataTable collectionMembers)
        {
            AssignmentDetailsCollection colMembers = new AssignmentDetailsCollection();
            AssignmentDetails obj = null;

            foreach (DataRow drMember in collectionMembers.Rows)
            {
                obj = new AssignmentDetails();
                obj.ID = (int)drMember["WMSourceID"];
                obj.InstanceNumber = (int)drMember["JobInstanceNumber"];

                obj.Workers = new WorkerCollection();
                Worker objWorker = new Worker();
                objWorker.UserID = drMember["UserID"].ToString();
                obj.Workers.Add(objWorker);

                obj.DueDate = (DateTime)drMember["DateChangeDetected"];
                colMembers.Add(obj);
            }

            return colMembers;
        }
コード例 #2
0
        public static WorkerCollection GetSiteContacts()
        {
            DataTable dtResults = null;
            FinalBuild.DataAccess objADO = Domain.GetADOInstance(Domain.eConnectionName.Metadata);
            string strStoredProcedure = "selHansenSiteContacts";
            dtResults = objADO.GetDataTable(strStoredProcedure, "SiteContacts");
            Worker objWorker;
            WorkerCollection colMembers = new WorkerCollection();

            foreach (DataRow drMember in dtResults.Rows)
            {
                objWorker = new Worker();
                objWorker.LoginName = drMember["NTLoginID"].ToString();
                if (drMember["EmpSurname"] != System.DBNull.Value)
                {
                    objWorker.Surname = drMember["EmpSurname"].ToString();
                }
                if (drMember["EmpForenames"] != System.DBNull.Value)
                {
                    objWorker.Forenames = drMember["EmpForenames"].ToString();
                }
                if (drMember["EmpNo"] != System.DBNull.Value)
                {
                    objWorker.EmpNo = drMember["EmpNo"].ToString();
                }

                colMembers.Add(objWorker);

            }

            return colMembers;
        }
コード例 #3
0
        public static WorkerCollection Populate(DataTable collectionMembers)
        {
            WorkerCollection colMembers = new WorkerCollection();
            Worker objWorker = null;

            foreach (DataRow drMember in collectionMembers.Rows)
            {
                objWorker = new Worker();
                objWorker.LoginName = drMember["ADLoginID"].ToString();
                objWorker.UserID = objWorker.LoginName;

                objWorker.EmpNo = drMember["EmployeeNo"].ToString();
                if (drMember["Surname"] != System.DBNull.Value)
                {
                    objWorker.Surname = drMember["Surname"].ToString();
                }
                if (drMember["Forenames"] != System.DBNull.Value)
                {
                    objWorker.Forenames = drMember["Forenames"].ToString();
                }
                if (drMember["PreferredName"] != System.DBNull.Value)
                {
                    objWorker.EmpPrefname = drMember["PreferredName"].ToString();
                }
                else
                {
                    objWorker.EmpPrefname = objWorker.Forenames;
                }
                /*
                if (drMember["EmpAddress"] != System.DBNull.Value)
                {
                    objWorker.EmpAddress = drMember["EmpAddress"].ToString();
                }
                else
                {
                */ 
                    objWorker.EmpAddress = string.Empty;
                /* } */
                if (!drMember["EmailAddress"].Equals(DBNull.Value))
                {
                    objWorker.Email = drMember["EmailAddress"].ToString();
                }
                if (!drMember["MobileNumber"].Equals(DBNull.Value))
                {
                    objWorker.MobileNo = drMember["MobileNumber"].ToString();
                }
                
                // Add to Collection
                colMembers.Add(objWorker);
            }

            return colMembers;
        }