Exemple #1
0
        internal static int RemoveProjectPerson(ProjectPerson obj)
        {
            if (obj == null)
            {
                return(-1);
            }
            SqlCommand comm = new SqlCommand();

            try {
                //comm.CommandText = //Insert Sproc Name Here;
                comm.Parameters.AddWithValue("@" + ProjectPerson.db_ID, obj.ID);
                return(UpdateObject(comm));
            } catch (Exception ex) {
            }
            return(-1);
        }
Exemple #2
0
        /// <summary>
        /// Attempts to add a database entry corresponding to the given ProjectPerson
        /// </summary>
        /// <remarks></remarks>

        internal static int AddProjectPerson(ProjectPerson obj)
        {
            if (obj == null)
            {
                return(-1);
            }
            SqlCommand comm = new SqlCommand("sproc_ProjectPersonAdd");

            try {
                comm.Parameters.AddWithValue("@" + ProjectPerson.db_Project, obj.ProjectID);
                comm.Parameters.AddWithValue("@" + ProjectPerson.db_Person, obj.Person);
                comm.Parameters.AddWithValue("@" + ProjectPerson.db_DateAssigned, obj.DateAssigned);
                return(AddObject(comm, "@" + ProjectPerson.db_ID));
            } catch (Exception ex) {
            }
            return(-1);
        }
Exemple #3
0
        /// <summary>
        /// Gets the SQLCode.ProjectPersoncorresponding with the given ID
        /// </summary>
        /// <remarks></remarks>

        public static ProjectPerson GetProjectPerson(int id)
        {
            SqlCommand    comm   = new SqlCommand("sprocProjectPersonGet");
            ProjectPerson retObj = null;

            try {
                comm.Parameters.AddWithValue("@" + ProjectPerson.db_ID, id);
                SqlDataReader dr = GetDataReader(comm);
                while (dr.Read())
                {
                    retObj = new ProjectPerson(dr);
                }
                comm.Connection.Close();
            } catch (Exception ex) {
                comm.Connection.Close();
            }
            return(retObj);
        }
Exemple #4
0
        /// <summary>
        /// Gets the SQLCode.ProjectPerson correposponding with the given ID
        /// </summary>
        /// <remarks></remarks>

        public static ProjectPerson GetProjectPerson(String idstring, Boolean retNewObject)
        {
            ProjectPerson retObject = null;
            int           ID;

            if (int.TryParse(idstring, out ID))
            {
                if (ID == -1 && retNewObject)
                {
                    retObject    = new ProjectPerson();
                    retObject.ID = -1;
                }
                else if (ID >= 0)
                {
                    retObject = GetProjectPerson(ID);
                }
            }
            return(retObject);
        }
Exemple #5
0
        /// <summary>
        /// Gets a list of all SQLCode.ProjectPerson objects from the database for
        /// a given Person.
        /// </summary>
        /// <remarks></remarks>
        public static List <ProjectPerson> GetProjectPerson(Person p)
        {
            SqlCommand           comm    = new SqlCommand("sprocProjectPersonsGetForPerson");
            List <ProjectPerson> retList = new List <ProjectPerson>();

            try {
                comm.Parameters.AddWithValue("@" + ProjectPerson.db_Person, p.ID);
                comm.CommandType = System.Data.CommandType.StoredProcedure;
                SqlDataReader dr = GetDataReader(comm);
                while (dr.Read())
                {
                    ProjectPerson pp = new ProjectPerson(dr);
                    pp.Project = new Project(dr);
                    pp.Person  = p;
                    retList.Add(pp);
                }
                comm.Connection.Close();
            } catch (Exception ex) {
                comm.Connection.Close();
            }
            return(retList);
        }