Ejemplo n.º 1
0
        public bool Insert(Aluminies aluminies)
        {
            int          autonumber         = 0;
            AluminiesDAC aluminiesComponent = new AluminiesDAC();
            bool         endedSuccessfuly   = aluminiesComponent.InsertNewAluminies(ref autonumber, aluminies.AluminiFor, aluminies.Department, aluminies.FirstName, aluminies.MiddleName, aluminies.FamilyName, aluminies.YearofJoining, aluminies.YearofGraduation, aluminies.UniversityNumber, aluminies.Speciality, aluminies.Email, aluminies.Contact1, aluminies.Contact2, aluminies.Contact3, aluminies.MedicalSchool, aluminies.MedicalSchoolCity, aluminies.Sponsor, aluminies.CurrentPosition, aluminies.CurrentWorkPlace, aluminies.Certificates, aluminies.Photo, aluminies.ScannedDocument, aluminies.ScannedDocumentTitle, aluminies.ScannedDocumentTitle2, aluminies.ScannedDocument2, aluminies.ScannedDocumentTitle3, aluminies.ScannedDocument3, aluminies.ScannedDocumentTitle4, aluminies.ScannedDocument4, aluminies.ScannedDocumentTitle5, aluminies.ScannedDocument5);

            if (endedSuccessfuly)
            {
                aluminies.Id = autonumber;
            }
            return(endedSuccessfuly);
        }
Ejemplo n.º 2
0
        public Aluminies GetByID(int _id)
        {
            AluminiesDAC _aluminiesComponent = new AluminiesDAC();
            IDataReader  reader     = _aluminiesComponent.GetByIDAluminies(_id);
            Aluminies    _aluminies = null;

            while (reader.Read())
            {
                _aluminies = new Aluminies();
                if (reader["Id"] != DBNull.Value)
                {
                    _aluminies.Id = Convert.ToInt32(reader["Id"]);
                }
                if (reader["AluminiFor"] != DBNull.Value)
                {
                    _aluminies.AluminiFor = Convert.ToString(reader["AluminiFor"]);
                }
                if (reader["Department"] != DBNull.Value)
                {
                    _aluminies.Department = Convert.ToString(reader["Department"]);
                }
                if (reader["FirstName"] != DBNull.Value)
                {
                    _aluminies.FirstName = Convert.ToString(reader["FirstName"]);
                }
                if (reader["MiddleName"] != DBNull.Value)
                {
                    _aluminies.MiddleName = Convert.ToString(reader["MiddleName"]);
                }
                if (reader["FamilyName"] != DBNull.Value)
                {
                    _aluminies.FamilyName = Convert.ToString(reader["FamilyName"]);
                }
                if (reader["YearofJoining"] != DBNull.Value)
                {
                    _aluminies.YearofJoining = Convert.ToInt32(reader["YearofJoining"]);
                }
                if (reader["YearofGraduation"] != DBNull.Value)
                {
                    _aluminies.YearofGraduation = Convert.ToInt32(reader["YearofGraduation"]);
                }
                if (reader["UniversityNumber"] != DBNull.Value)
                {
                    _aluminies.UniversityNumber = Convert.ToString(reader["UniversityNumber"]);
                }
                if (reader["Speciality"] != DBNull.Value)
                {
                    _aluminies.Speciality = Convert.ToString(reader["Speciality"]);
                }
                if (reader["Email"] != DBNull.Value)
                {
                    _aluminies.Email = Convert.ToString(reader["Email"]);
                }
                if (reader["Contact1"] != DBNull.Value)
                {
                    _aluminies.Contact1 = Convert.ToString(reader["Contact1"]);
                }
                if (reader["Contact2"] != DBNull.Value)
                {
                    _aluminies.Contact2 = Convert.ToString(reader["Contact2"]);
                }
                if (reader["Contact3"] != DBNull.Value)
                {
                    _aluminies.Contact3 = Convert.ToString(reader["Contact3"]);
                }
                if (reader["MedicalSchool"] != DBNull.Value)
                {
                    _aluminies.MedicalSchool = Convert.ToString(reader["MedicalSchool"]);
                }
                if (reader["MedicalSchoolCity"] != DBNull.Value)
                {
                    _aluminies.MedicalSchoolCity = Convert.ToString(reader["MedicalSchoolCity"]);
                }
                if (reader["Sponsor"] != DBNull.Value)
                {
                    _aluminies.Sponsor = Convert.ToString(reader["Sponsor"]);
                }
                if (reader["CurrentPosition"] != DBNull.Value)
                {
                    _aluminies.CurrentPosition = Convert.ToString(reader["CurrentPosition"]);
                }
                if (reader["CurrentWorkPlace"] != DBNull.Value)
                {
                    _aluminies.CurrentWorkPlace = Convert.ToString(reader["CurrentWorkPlace"]);
                }
                if (reader["Certificates"] != DBNull.Value)
                {
                    _aluminies.Certificates = Convert.ToString(reader["Certificates"]);
                }
                if (reader["Photo"] != DBNull.Value)
                {
                    _aluminies.Photo = Convert.ToString(reader["Photo"]);
                }
                if (reader["ScannedDocument"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument = Convert.ToString(reader["ScannedDocument"]);
                }
                if (reader["ScannedDocumentTitle"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle = Convert.ToString(reader["ScannedDocumentTitle"]);
                }
                if (reader["ScannedDocumentTitle2"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle2 = Convert.ToString(reader["ScannedDocumentTitle2"]);
                }
                if (reader["ScannedDocument2"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument2 = Convert.ToString(reader["ScannedDocument2"]);
                }
                if (reader["ScannedDocumentTitle3"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle3 = Convert.ToString(reader["ScannedDocumentTitle3"]);
                }
                if (reader["ScannedDocument3"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument3 = Convert.ToString(reader["ScannedDocument3"]);
                }
                if (reader["ScannedDocumentTitle4"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle4 = Convert.ToString(reader["ScannedDocumentTitle4"]);
                }
                if (reader["ScannedDocument4"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument4 = Convert.ToString(reader["ScannedDocument4"]);
                }
                if (reader["ScannedDocumentTitle5"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle5 = Convert.ToString(reader["ScannedDocumentTitle5"]);
                }
                if (reader["ScannedDocument5"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument5 = Convert.ToString(reader["ScannedDocument5"]);
                }
                _aluminies.NewRecord = false;
            }
            reader.Close();
            return(_aluminies);
        }
Ejemplo n.º 3
0
        public bool Update(Aluminies aluminies, int old_id)
        {
            AluminiesDAC aluminiesComponent = new AluminiesDAC();

            return(aluminiesComponent.UpdateAluminies(aluminies.AluminiFor, aluminies.Department, aluminies.FirstName, aluminies.MiddleName, aluminies.FamilyName, aluminies.YearofJoining, aluminies.YearofGraduation, aluminies.UniversityNumber, aluminies.Speciality, aluminies.Email, aluminies.Contact1, aluminies.Contact2, aluminies.Contact3, aluminies.MedicalSchool, aluminies.MedicalSchoolCity, aluminies.Sponsor, aluminies.CurrentPosition, aluminies.CurrentWorkPlace, aluminies.Certificates, aluminies.Photo, aluminies.ScannedDocument, aluminies.ScannedDocumentTitle, aluminies.ScannedDocumentTitle2, aluminies.ScannedDocument2, aluminies.ScannedDocumentTitle3, aluminies.ScannedDocument3, aluminies.ScannedDocumentTitle4, aluminies.ScannedDocument4, aluminies.ScannedDocumentTitle5, aluminies.ScannedDocument5, old_id));
        }
Ejemplo n.º 4
0
        public List <Aluminies> GetAllByDepartmentYearAndType(string type, string department, string yearofJoining, string yearofGraduation)
        {
            string where = "";
            if (!string.IsNullOrEmpty(type))
            {
                where += " AluminiFor = '" + type + "' AND";
            }
            if (!string.IsNullOrEmpty(department))
            {
                where += " Department = '" + department + "' AND";
            }
            if (!string.IsNullOrEmpty(yearofJoining))
            {
                where += " YearofJoining = " + yearofJoining + " AND";
            }
            if (!string.IsNullOrEmpty(yearofGraduation))
            {
                where += " yearofGraduation = " + yearofGraduation + " AND";
            }
            if (!string.IsNullOrEmpty(where))
            {
                where = where.Remove(where.Length - 3, 3);
            }
            AluminiesDAC     _aluminiesComponent = new AluminiesDAC();
            IDataReader      reader         = _aluminiesComponent.GetAllAluminies(where).CreateDataReader();
            List <Aluminies> _aluminiesList = new List <Aluminies>();

            while (reader.Read())
            {
                if (_aluminiesList == null)
                {
                    _aluminiesList = new List <Aluminies>();
                }
                Aluminies _aluminies = new Aluminies();
                if (reader["Id"] != DBNull.Value)
                {
                    _aluminies.Id = Convert.ToInt32(reader["Id"]);
                }
                if (reader["AluminiFor"] != DBNull.Value)
                {
                    _aluminies.AluminiFor = Convert.ToString(reader["AluminiFor"]);
                }
                if (reader["Department"] != DBNull.Value)
                {
                    _aluminies.Department = Convert.ToString(reader["Department"]);
                }
                if (reader["FirstName"] != DBNull.Value)
                {
                    _aluminies.FirstName = Convert.ToString(reader["FirstName"]);
                }
                if (reader["MiddleName"] != DBNull.Value)
                {
                    _aluminies.MiddleName = Convert.ToString(reader["MiddleName"]);
                }
                if (reader["FamilyName"] != DBNull.Value)
                {
                    _aluminies.FamilyName = Convert.ToString(reader["FamilyName"]);
                }
                if (reader["YearofJoining"] != DBNull.Value)
                {
                    _aluminies.YearofJoining = Convert.ToInt32(reader["YearofJoining"]);
                }
                if (reader["YearofGraduation"] != DBNull.Value)
                {
                    _aluminies.YearofGraduation = Convert.ToInt32(reader["YearofGraduation"]);
                }
                if (reader["UniversityNumber"] != DBNull.Value)
                {
                    _aluminies.UniversityNumber = Convert.ToString(reader["UniversityNumber"]);
                }
                if (reader["Speciality"] != DBNull.Value)
                {
                    _aluminies.Speciality = Convert.ToString(reader["Speciality"]);
                }
                if (reader["Email"] != DBNull.Value)
                {
                    _aluminies.Email = Convert.ToString(reader["Email"]);
                }
                if (reader["Contact1"] != DBNull.Value)
                {
                    _aluminies.Contact1 = Convert.ToString(reader["Contact1"]);
                }
                if (reader["Contact2"] != DBNull.Value)
                {
                    _aluminies.Contact2 = Convert.ToString(reader["Contact2"]);
                }
                if (reader["Contact3"] != DBNull.Value)
                {
                    _aluminies.Contact3 = Convert.ToString(reader["Contact3"]);
                }
                if (reader["MedicalSchool"] != DBNull.Value)
                {
                    _aluminies.MedicalSchool = Convert.ToString(reader["MedicalSchool"]);
                }
                if (reader["MedicalSchoolCity"] != DBNull.Value)
                {
                    _aluminies.MedicalSchoolCity = Convert.ToString(reader["MedicalSchoolCity"]);
                }
                if (reader["Sponsor"] != DBNull.Value)
                {
                    _aluminies.Sponsor = Convert.ToString(reader["Sponsor"]);
                }
                if (reader["CurrentPosition"] != DBNull.Value)
                {
                    _aluminies.CurrentPosition = Convert.ToString(reader["CurrentPosition"]);
                }
                if (reader["CurrentWorkPlace"] != DBNull.Value)
                {
                    _aluminies.CurrentWorkPlace = Convert.ToString(reader["CurrentWorkPlace"]);
                }
                if (reader["Certificates"] != DBNull.Value)
                {
                    _aluminies.Certificates = Convert.ToString(reader["Certificates"]);
                }
                if (reader["Photo"] != DBNull.Value)
                {
                    _aluminies.Photo = Convert.ToString(reader["Photo"]);
                }
                if (reader["ScannedDocument"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument = Convert.ToString(reader["ScannedDocument"]);
                }
                if (reader["ScannedDocumentTitle"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle = Convert.ToString(reader["ScannedDocumentTitle"]);
                }
                if (reader["ScannedDocumentTitle2"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle2 = Convert.ToString(reader["ScannedDocumentTitle2"]);
                }
                if (reader["ScannedDocument2"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument2 = Convert.ToString(reader["ScannedDocument2"]);
                }
                if (reader["ScannedDocumentTitle3"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle3 = Convert.ToString(reader["ScannedDocumentTitle3"]);
                }
                if (reader["ScannedDocument3"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument3 = Convert.ToString(reader["ScannedDocument3"]);
                }
                if (reader["ScannedDocumentTitle4"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle4 = Convert.ToString(reader["ScannedDocumentTitle4"]);
                }
                if (reader["ScannedDocument4"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument4 = Convert.ToString(reader["ScannedDocument4"]);
                }
                if (reader["ScannedDocumentTitle5"] != DBNull.Value)
                {
                    _aluminies.ScannedDocumentTitle5 = Convert.ToString(reader["ScannedDocumentTitle5"]);
                }
                if (reader["ScannedDocument5"] != DBNull.Value)
                {
                    _aluminies.ScannedDocument5 = Convert.ToString(reader["ScannedDocument5"]);
                }
                _aluminies.NewRecord = false;
                _aluminiesList.Add(_aluminies);
            }
            reader.Close();
            return(_aluminiesList);
        }