public List<AbstractAuthors> GetAll() { AbstractAuthorsDAC _abstractAuthorsComponent = new AbstractAuthorsDAC(); IDataReader reader = _abstractAuthorsComponent.GetAllAbstractAuthors().CreateDataReader(); List<AbstractAuthors> _abstractAuthorsList = new List<AbstractAuthors>(); while(reader.Read()) { if(_abstractAuthorsList == null) _abstractAuthorsList = new List<AbstractAuthors>(); AbstractAuthors _abstractAuthors = new AbstractAuthors(); if(reader["AbstractAuthorId"] != DBNull.Value) _abstractAuthors.AbstractAuthorId = Convert.ToInt32(reader["AbstractAuthorId"]); if(reader["AbstractId"] != DBNull.Value) _abstractAuthors.AbstractId = Convert.ToInt32(reader["AbstractId"]); if(reader["FirstName"] != DBNull.Value) _abstractAuthors.FirstName = Convert.ToString(reader["FirstName"]); if(reader["FamilyName"] != DBNull.Value) _abstractAuthors.FamilyName = Convert.ToString(reader["FamilyName"]); if(reader["Title"] != DBNull.Value) _abstractAuthors.Title = Convert.ToString(reader["Title"]); if(reader["Degree"] != DBNull.Value) _abstractAuthors.Degree = Convert.ToString(reader["Degree"]); if(reader["Email"] != DBNull.Value) _abstractAuthors.Email = Convert.ToString(reader["Email"]); if(reader["Address"] != DBNull.Value) _abstractAuthors.Address = Convert.ToString(reader["Address"]); if(reader["PhoneNumber"] != DBNull.Value) _abstractAuthors.PhoneNumber = Convert.ToString(reader["PhoneNumber"]); if(reader["AffilitationDepartment"] != DBNull.Value) _abstractAuthors.AffilitationDepartment = Convert.ToString(reader["AffilitationDepartment"]); if(reader["AffilitationInstitutionHospital"] != DBNull.Value) _abstractAuthors.AffilitationInstitutionHospital = Convert.ToString(reader["AffilitationInstitutionHospital"]); if(reader["AffilitationCity"] != DBNull.Value) _abstractAuthors.AffilitationCity = Convert.ToString(reader["AffilitationCity"]); if(reader["AffilitationCountry"] != DBNull.Value) _abstractAuthors.AffilitationCountry = Convert.ToString(reader["AffilitationCountry"]); if(reader["Country"] != DBNull.Value) _abstractAuthors.Country = Convert.ToString(reader["Country"]); if(reader["POBox"] != DBNull.Value) _abstractAuthors.POBox = Convert.ToString(reader["POBox"]); if(reader["ZipCode"] != DBNull.Value) _abstractAuthors.ZipCode = Convert.ToString(reader["ZipCode"]); if(reader["City"] != DBNull.Value) _abstractAuthors.City = Convert.ToString(reader["City"]); if(reader["IsMainAuthor"] != DBNull.Value) _abstractAuthors.IsMainAuthor = Convert.ToBoolean(reader["IsMainAuthor"]); if(reader["PhoneNumberAreaCode"] != DBNull.Value) _abstractAuthors.PhoneNumberAreaCode = Convert.ToString(reader["PhoneNumberAreaCode"]); _abstractAuthors.NewRecord = false; _abstractAuthorsList.Add(_abstractAuthors); } reader.Close(); return _abstractAuthorsList; }
public bool Update(AbstractAuthors abstractauthors ,int old_abstractAuthorId) { AbstractAuthorsDAC abstractauthorsComponent = new AbstractAuthorsDAC(); return abstractauthorsComponent.UpdateAbstractAuthors( abstractauthors.AbstractId, abstractauthors.FirstName, abstractauthors.FamilyName, abstractauthors.Title, abstractauthors.Degree, abstractauthors.Email, abstractauthors.Address, abstractauthors.PhoneNumber, abstractauthors.AffilitationDepartment, abstractauthors.AffilitationInstitutionHospital, abstractauthors.AffilitationCity, abstractauthors.AffilitationCountry, abstractauthors.Country, abstractauthors.POBox, abstractauthors.ZipCode, abstractauthors.City, abstractauthors.IsMainAuthor, abstractauthors.PhoneNumberAreaCode, old_abstractAuthorId); }
public bool Insert(AbstractAuthors abstractauthors) { int autonumber = 0; AbstractAuthorsDAC abstractauthorsComponent = new AbstractAuthorsDAC(); bool endedSuccessfuly = abstractauthorsComponent.InsertNewAbstractAuthors( ref autonumber, abstractauthors.AbstractId, abstractauthors.FirstName, abstractauthors.FamilyName, abstractauthors.Title, abstractauthors.Degree, abstractauthors.Email, abstractauthors.Address, abstractauthors.PhoneNumber, abstractauthors.AffilitationDepartment, abstractauthors.AffilitationInstitutionHospital, abstractauthors.AffilitationCity, abstractauthors.AffilitationCountry, abstractauthors.Country, abstractauthors.POBox, abstractauthors.ZipCode, abstractauthors.City, abstractauthors.IsMainAuthor, abstractauthors.PhoneNumberAreaCode); if(endedSuccessfuly) { abstractauthors.AbstractAuthorId = autonumber; } return endedSuccessfuly; }