Exemple #1
0
        public bool Insert(int DepartmentId, string DivisionName, string DivisionDescription, string Phone1, string Phone2, string Fax1, string Fax2)
        {
            DivisionsDAC divisionsComponent = new DivisionsDAC();
            int          DivisionId         = 0;

            return(divisionsComponent.InsertNewDivisions(ref DivisionId, DepartmentId, DivisionName, DivisionDescription, Phone1, Phone2, Fax1, Fax2));
        }
Exemple #2
0
        public bool Insert(Divisions divisions)
        {
            int          autonumber         = 0;
            DivisionsDAC divisionsComponent = new DivisionsDAC();
            bool         endedSuccessfuly   = divisionsComponent.InsertNewDivisions(ref autonumber, divisions.DepartmentId, divisions.DivisionName, divisions.DivisionDescription, divisions.Phone1, divisions.Phone2, divisions.Fax1, divisions.Fax2);

            if (endedSuccessfuly)
            {
                divisions.DivisionId = autonumber;
            }
            return(endedSuccessfuly);
        }
Exemple #3
0
        public List <Divisions> GetAll()
        {
            DivisionsDAC     _divisionsComponent = new DivisionsDAC();
            IDataReader      reader         = _divisionsComponent.GetAllDivisions().CreateDataReader();
            List <Divisions> _divisionsList = new List <Divisions>();

            while (reader.Read())
            {
                if (_divisionsList == null)
                {
                    _divisionsList = new List <Divisions>();
                }
                Divisions _divisions = new Divisions();
                if (reader["DivisionId"] != DBNull.Value)
                {
                    _divisions.DivisionId = Convert.ToInt32(reader["DivisionId"]);
                }
                if (reader["DepartmentId"] != DBNull.Value)
                {
                    _divisions.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
                }
                if (reader["DivisionName"] != DBNull.Value)
                {
                    _divisions.DivisionName = Convert.ToString(reader["DivisionName"]);
                }
                if (reader["DivisionDescription"] != DBNull.Value)
                {
                    _divisions.DivisionDescription = Convert.ToString(reader["DivisionDescription"]);
                }
                if (reader["Phone1"] != DBNull.Value)
                {
                    _divisions.Phone1 = Convert.ToString(reader["Phone1"]);
                }
                if (reader["Phone2"] != DBNull.Value)
                {
                    _divisions.Phone2 = Convert.ToString(reader["Phone2"]);
                }
                if (reader["Fax1"] != DBNull.Value)
                {
                    _divisions.Fax1 = Convert.ToString(reader["Fax1"]);
                }
                if (reader["Fax2"] != DBNull.Value)
                {
                    _divisions.Fax2 = Convert.ToString(reader["Fax2"]);
                }
                _divisions.NewRecord = false;
                _divisionsList.Add(_divisions);
            }
            reader.Close();
            return(_divisionsList);
        }
Exemple #4
0
        public Divisions GetByID(int _divisionId)
        {
            DivisionsDAC _divisionsComponent = new DivisionsDAC();
            IDataReader  reader     = _divisionsComponent.GetByIDDivisions(_divisionId);
            Divisions    _divisions = null;

            while (reader.Read())
            {
                _divisions = new Divisions();
                if (reader["DivisionId"] != DBNull.Value)
                {
                    _divisions.DivisionId = Convert.ToInt32(reader["DivisionId"]);
                }
                if (reader["DepartmentId"] != DBNull.Value)
                {
                    _divisions.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
                }
                if (reader["DivisionName"] != DBNull.Value)
                {
                    _divisions.DivisionName = Convert.ToString(reader["DivisionName"]);
                }
                if (reader["DivisionDescription"] != DBNull.Value)
                {
                    _divisions.DivisionDescription = Convert.ToString(reader["DivisionDescription"]);
                }
                if (reader["Phone1"] != DBNull.Value)
                {
                    _divisions.Phone1 = Convert.ToString(reader["Phone1"]);
                }
                if (reader["Phone2"] != DBNull.Value)
                {
                    _divisions.Phone2 = Convert.ToString(reader["Phone2"]);
                }
                if (reader["Fax1"] != DBNull.Value)
                {
                    _divisions.Fax1 = Convert.ToString(reader["Fax1"]);
                }
                if (reader["Fax2"] != DBNull.Value)
                {
                    _divisions.Fax2 = Convert.ToString(reader["Fax2"]);
                }
                _divisions.NewRecord = false;
            }
            reader.Close();
            return(_divisions);
        }
Exemple #5
0
        public int UpdateDataset(System.Data.DataSet dataset)
        {
            DivisionsDAC divisionscomponent = new DivisionsDAC();

            return(divisionscomponent.UpdateDataset(dataset));
        }
Exemple #6
0
        public void Delete(int Original_DivisionId)
        {
            DivisionsDAC divisionsComponent = new DivisionsDAC();

            divisionsComponent.DeleteDivisions(Original_DivisionId);
        }
Exemple #7
0
        public bool Update(int DepartmentId, string DivisionName, string DivisionDescription, string Phone1, string Phone2, string Fax1, string Fax2, int Original_DivisionId)
        {
            DivisionsDAC divisionsComponent = new DivisionsDAC();

            return(divisionsComponent.UpdateDivisions(DepartmentId, DivisionName, DivisionDescription, Phone1, Phone2, Fax1, Fax2, Original_DivisionId));
        }
Exemple #8
0
        public bool Update(Divisions divisions, int old_divisionId)
        {
            DivisionsDAC divisionsComponent = new DivisionsDAC();

            return(divisionsComponent.UpdateDivisions(divisions.DepartmentId, divisions.DivisionName, divisions.DivisionDescription, divisions.Phone1, divisions.Phone2, divisions.Fax1, divisions.Fax2, old_divisionId));
        }