Esempio n. 1
0
        public bool Insert(string Name, Guid RowGuid, DateTime ModifiedDate)
        {
            SiteSectionStatusDAC sitesectionstatusComponent = new SiteSectionStatusDAC();
            int SiteSectionStatusId = 0;

            return(sitesectionstatusComponent.InsertNewSiteSectionStatus(ref SiteSectionStatusId, Name, RowGuid, ModifiedDate));
        }
Esempio n. 2
0
        public List <SiteSectionStatus> GetAll()
        {
            SiteSectionStatusDAC     _siteSectionStatusComponent = new SiteSectionStatusDAC();
            IDataReader              reader = _siteSectionStatusComponent.GetAllSiteSectionStatus().CreateDataReader();
            List <SiteSectionStatus> _siteSectionStatusList = new List <SiteSectionStatus>();

            while (reader.Read())
            {
                if (_siteSectionStatusList == null)
                {
                    _siteSectionStatusList = new List <SiteSectionStatus>();
                }
                SiteSectionStatus _siteSectionStatus = new SiteSectionStatus();
                if (reader["SiteSectionStatusId"] != DBNull.Value)
                {
                    _siteSectionStatus.SiteSectionStatusId = Convert.ToInt32(reader["SiteSectionStatusId"]);
                }
                if (reader["Name"] != DBNull.Value)
                {
                    _siteSectionStatus.Name = Convert.ToString(reader["Name"]);
                }
                if (reader["RowGuid"] != DBNull.Value)
                {
                    _siteSectionStatus.RowGuid = new Guid(reader["RowGuid"].ToString());
                }
                if (reader["ModifiedDate"] != DBNull.Value)
                {
                    _siteSectionStatus.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
                }
                _siteSectionStatus.NewRecord = false;
                _siteSectionStatusList.Add(_siteSectionStatus);
            }
            reader.Close();
            return(_siteSectionStatusList);
        }
Esempio n. 3
0
        public SiteSectionStatus GetByID(int _siteSectionStatusId)
        {
            SiteSectionStatusDAC _siteSectionStatusComponent = new SiteSectionStatusDAC();
            IDataReader          reader             = _siteSectionStatusComponent.GetByIDSiteSectionStatus(_siteSectionStatusId);
            SiteSectionStatus    _siteSectionStatus = null;

            while (reader.Read())
            {
                _siteSectionStatus = new SiteSectionStatus();
                if (reader["SiteSectionStatusId"] != DBNull.Value)
                {
                    _siteSectionStatus.SiteSectionStatusId = Convert.ToInt32(reader["SiteSectionStatusId"]);
                }
                if (reader["Name"] != DBNull.Value)
                {
                    _siteSectionStatus.Name = Convert.ToString(reader["Name"]);
                }
                if (reader["RowGuid"] != DBNull.Value)
                {
                    _siteSectionStatus.RowGuid = new Guid(reader["RowGuid"].ToString());
                }
                if (reader["ModifiedDate"] != DBNull.Value)
                {
                    _siteSectionStatus.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
                }
                _siteSectionStatus.NewRecord = false;
            }
            reader.Close();
            return(_siteSectionStatus);
        }
Esempio n. 4
0
        public bool Insert(SiteSectionStatus sitesectionstatus)
        {
            int autonumber = 0;
            SiteSectionStatusDAC sitesectionstatusComponent = new SiteSectionStatusDAC();
            bool endedSuccessfuly = sitesectionstatusComponent.InsertNewSiteSectionStatus(ref autonumber, sitesectionstatus.Name, sitesectionstatus.RowGuid, sitesectionstatus.ModifiedDate);

            if (endedSuccessfuly)
            {
                sitesectionstatus.SiteSectionStatusId = autonumber;
            }
            return(endedSuccessfuly);
        }
Esempio n. 5
0
        public bool Update(string Name, Guid RowGuid, DateTime ModifiedDate, int Original_SiteSectionStatusId)
        {
            SiteSectionStatusDAC sitesectionstatusComponent = new SiteSectionStatusDAC();

            return(sitesectionstatusComponent.UpdateSiteSectionStatus(Name, RowGuid, ModifiedDate, Original_SiteSectionStatusId));
        }
Esempio n. 6
0
        public bool Update(SiteSectionStatus sitesectionstatus, int old_siteSectionStatusId)
        {
            SiteSectionStatusDAC sitesectionstatusComponent = new SiteSectionStatusDAC();

            return(sitesectionstatusComponent.UpdateSiteSectionStatus(sitesectionstatus.Name, sitesectionstatus.RowGuid, sitesectionstatus.ModifiedDate, old_siteSectionStatusId));
        }
Esempio n. 7
0
        public int UpdateDataset(System.Data.DataSet dataset)
        {
            SiteSectionStatusDAC sitesectionstatuscomponent = new SiteSectionStatusDAC();

            return(sitesectionstatuscomponent.UpdateDataset(dataset));
        }
Esempio n. 8
0
        public void Delete(int Original_SiteSectionStatusId)
        {
            SiteSectionStatusDAC sitesectionstatusComponent = new SiteSectionStatusDAC();

            sitesectionstatusComponent.DeleteSiteSectionStatus(Original_SiteSectionStatusId);
        }