public IList<Core.Business.CommissionedProjectType> GetAllCommissionedProjectType()
        {
            IList<Core.Business.CommissionedProjectType> commissionedProjectTypelist = new List<Core.Business.CommissionedProjectType>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedProjectTypesAll");

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.CommissionedProjectType commissionedProjectType = new Core.Business.CommissionedProjectType();

                    if (!reader.IsDBNull(0)) commissionedProjectType.Id = reader.GetGuid(0);
                    if (!reader.IsDBNull(1)) commissionedProjectType.ProjectTpye = reader.GetString(1);
                    if (!reader.IsDBNull(2)) commissionedProjectType.Index = reader.GetInt32(2);

                    commissionedProjectType.MarkOld();
                    commissionedProjectTypelist.Add(commissionedProjectType);
                }
                reader.Close();
            }
            return commissionedProjectTypelist;
        }