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); }
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)); }