public List<AbstractAuthorsLanguage> GetAll()
{
AbstractAuthorsLanguageDAC _abstractAuthorsLanguageComponent = new AbstractAuthorsLanguageDAC();
IDataReader reader = _abstractAuthorsLanguageComponent.GetAllAbstractAuthorsLanguage().CreateDataReader();
List<AbstractAuthorsLanguage> _abstractAuthorsLanguageList = new List<AbstractAuthorsLanguage>();
while(reader.Read())
{
if(_abstractAuthorsLanguageList == null)
_abstractAuthorsLanguageList = new List<AbstractAuthorsLanguage>();
AbstractAuthorsLanguage _abstractAuthorsLanguage = new AbstractAuthorsLanguage();
if(reader["AbstractAuthorLanguageId"] != DBNull.Value)
_abstractAuthorsLanguage.AbstractAuthorLanguageId = Convert.ToInt32(reader["AbstractAuthorLanguageId"]);
if(reader["AbstractAuthorId"] != DBNull.Value)
_abstractAuthorsLanguage.AbstractAuthorId = Convert.ToInt32(reader["AbstractAuthorId"]);
if(reader["FirstName"] != DBNull.Value)
_abstractAuthorsLanguage.FirstName = Convert.ToString(reader["FirstName"]);
if(reader["FamilyName"] != DBNull.Value)
_abstractAuthorsLanguage.FamilyName = Convert.ToString(reader["FamilyName"]);
if(reader["Title"] != DBNull.Value)
_abstractAuthorsLanguage.Title = Convert.ToString(reader["Title"]);
if(reader["Degree"] != DBNull.Value)
_abstractAuthorsLanguage.Degree = Convert.ToString(reader["Degree"]);
if(reader["Email"] != DBNull.Value)
_abstractAuthorsLanguage.Email = Convert.ToString(reader["Email"]);
if(reader["Address"] != DBNull.Value)
_abstractAuthorsLanguage.Address = Convert.ToString(reader["Address"]);
if(reader["AffilitationDepartment"] != DBNull.Value)
_abstractAuthorsLanguage.AffilitationDepartment = Convert.ToString(reader["AffilitationDepartment"]);
if(reader["AffilitationInstitutionHospital"] != DBNull.Value)
_abstractAuthorsLanguage.AffilitationInstitutionHospital = Convert.ToString(reader["AffilitationInstitutionHospital"]);
if(reader["AffilitationCity"] != DBNull.Value)
_abstractAuthorsLanguage.AffilitationCity = Convert.ToString(reader["AffilitationCity"]);
if(reader["AffilitationCountry"] != DBNull.Value)
_abstractAuthorsLanguage.AffilitationCountry = Convert.ToString(reader["AffilitationCountry"]);
if(reader["Country"] != DBNull.Value)
_abstractAuthorsLanguage.Country = Convert.ToString(reader["Country"]);
if(reader["POBox"] != DBNull.Value)
_abstractAuthorsLanguage.POBox = Convert.ToString(reader["POBox"]);
if(reader["ZipCode"] != DBNull.Value)
_abstractAuthorsLanguage.ZipCode = Convert.ToString(reader["ZipCode"]);
if(reader["City"] != DBNull.Value)
_abstractAuthorsLanguage.City = Convert.ToString(reader["City"]);
if(reader["LanguageID"] != DBNull.Value)
_abstractAuthorsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
_abstractAuthorsLanguage.NewRecord = false;
_abstractAuthorsLanguageList.Add(_abstractAuthorsLanguage);
} reader.Close();
return _abstractAuthorsLanguageList;
}
public bool Update(AbstractAuthorsLanguage abstractauthorslanguage ,int old_abstractAuthorLanguageId)
{
AbstractAuthorsLanguageDAC abstractauthorslanguageComponent = new AbstractAuthorsLanguageDAC();
return abstractauthorslanguageComponent.UpdateAbstractAuthorsLanguage( abstractauthorslanguage.AbstractAuthorId, abstractauthorslanguage.FirstName, abstractauthorslanguage.FamilyName, abstractauthorslanguage.Title, abstractauthorslanguage.Degree, abstractauthorslanguage.Email, abstractauthorslanguage.Address, abstractauthorslanguage.AffilitationDepartment, abstractauthorslanguage.AffilitationInstitutionHospital, abstractauthorslanguage.AffilitationCity, abstractauthorslanguage.AffilitationCountry, abstractauthorslanguage.Country, abstractauthorslanguage.POBox, abstractauthorslanguage.ZipCode, abstractauthorslanguage.City, abstractauthorslanguage.LanguageID, old_abstractAuthorLanguageId);
}
public bool Insert(AbstractAuthorsLanguage abstractauthorslanguage)
{
int autonumber = 0;
AbstractAuthorsLanguageDAC abstractauthorslanguageComponent = new AbstractAuthorsLanguageDAC();
bool endedSuccessfuly = abstractauthorslanguageComponent.InsertNewAbstractAuthorsLanguage( ref autonumber, abstractauthorslanguage.AbstractAuthorId, abstractauthorslanguage.FirstName, abstractauthorslanguage.FamilyName, abstractauthorslanguage.Title, abstractauthorslanguage.Degree, abstractauthorslanguage.Email, abstractauthorslanguage.Address, abstractauthorslanguage.AffilitationDepartment, abstractauthorslanguage.AffilitationInstitutionHospital, abstractauthorslanguage.AffilitationCity, abstractauthorslanguage.AffilitationCountry, abstractauthorslanguage.Country, abstractauthorslanguage.POBox, abstractauthorslanguage.ZipCode, abstractauthorslanguage.City, abstractauthorslanguage.LanguageID);
if(endedSuccessfuly)
{
abstractauthorslanguage.AbstractAuthorLanguageId = autonumber;
}
return endedSuccessfuly;
}