Example #1
0
        public bool Insert(string ProgramTypeName)
        {
            ProgramTypeDAC programtypeComponent = new ProgramTypeDAC();
            int            ProgramTypeId        = 0;

            return(programtypeComponent.InsertNewProgramType(ref ProgramTypeId, ProgramTypeName));
        }
Example #2
0
        public List <ProgramType> GetAll()
        {
            ProgramTypeDAC     _programTypeComponent = new ProgramTypeDAC();
            IDataReader        reader           = _programTypeComponent.GetAllProgramType().CreateDataReader();
            List <ProgramType> _programTypeList = new List <ProgramType>();

            while (reader.Read())
            {
                if (_programTypeList == null)
                {
                    _programTypeList = new List <ProgramType>();
                }
                ProgramType _programType = new ProgramType();
                if (reader["ProgramTypeId"] != DBNull.Value)
                {
                    _programType.ProgramTypeId = Convert.ToInt32(reader["ProgramTypeId"]);
                }
                if (reader["ProgramTypeName"] != DBNull.Value)
                {
                    _programType.ProgramTypeName = Convert.ToString(reader["ProgramTypeName"]);
                }
                _programType.NewRecord = false;
                _programTypeList.Add(_programType);
            }
            reader.Close();
            return(_programTypeList);
        }
Example #3
0
        public bool Insert(ProgramType programtype)
        {
            int            autonumber           = 0;
            ProgramTypeDAC programtypeComponent = new ProgramTypeDAC();
            bool           endedSuccessfuly     = programtypeComponent.InsertNewProgramType(ref autonumber, programtype.ProgramTypeName);

            if (endedSuccessfuly)
            {
                programtype.ProgramTypeId = autonumber;
            }
            return(endedSuccessfuly);
        }
Example #4
0
        public ProgramType GetByID(int _programTypeId)
        {
            ProgramTypeDAC _programTypeComponent = new ProgramTypeDAC();
            IDataReader    reader       = _programTypeComponent.GetByIDProgramType(_programTypeId);
            ProgramType    _programType = null;

            while (reader.Read())
            {
                _programType = new ProgramType();
                if (reader["ProgramTypeId"] != DBNull.Value)
                {
                    _programType.ProgramTypeId = Convert.ToInt32(reader["ProgramTypeId"]);
                }
                if (reader["ProgramTypeName"] != DBNull.Value)
                {
                    _programType.ProgramTypeName = Convert.ToString(reader["ProgramTypeName"]);
                }
                _programType.NewRecord = false;
            }
            reader.Close();
            return(_programType);
        }
Example #5
0
        public void Delete(int Original_ProgramTypeId)
        {
            ProgramTypeDAC programtypeComponent = new ProgramTypeDAC();

            programtypeComponent.DeleteProgramType(Original_ProgramTypeId);
        }
Example #6
0
        public bool Update(string ProgramTypeName, int Original_ProgramTypeId)
        {
            ProgramTypeDAC programtypeComponent = new ProgramTypeDAC();

            return(programtypeComponent.UpdateProgramType(ProgramTypeName, Original_ProgramTypeId));
        }
Example #7
0
        public bool Update(ProgramType programtype, int old_programTypeId)
        {
            ProgramTypeDAC programtypeComponent = new ProgramTypeDAC();

            return(programtypeComponent.UpdateProgramType(programtype.ProgramTypeName, old_programTypeId));
        }
Example #8
0
        public int UpdateDataset(System.Data.DataSet dataset)
        {
            ProgramTypeDAC programtypecomponent = new ProgramTypeDAC();

            return(programtypecomponent.UpdateDataset(dataset));
        }