public bool Insert(AbstractsLanguage abstractslanguage) { int autonumber = 0; AbstractsLanguageDAC abstractslanguageComponent = new AbstractsLanguageDAC(); bool endedSuccessfuly = abstractslanguageComponent.InsertNewAbstractsLanguage(ref autonumber, abstractslanguage.AbstractId, abstractslanguage.AbstractTitle, abstractslanguage.AbstractIntro, abstractslanguage.CoverLetter, abstractslanguage.Topic, abstractslanguage.Background, abstractslanguage.Methods, abstractslanguage.Results, abstractslanguage.Conclusions, abstractslanguage.AbstractTerms, abstractslanguage.AbstractKeywords, abstractslanguage.LanguageID); if (endedSuccessfuly) { abstractslanguage.AbstractLanguageId = autonumber; } return(endedSuccessfuly); }
public AbstractsLanguage GetByID(int _abstractLanguageId) { AbstractsLanguageDAC _abstractsLanguageComponent = new AbstractsLanguageDAC(); IDataReader reader = _abstractsLanguageComponent.GetByIDAbstractsLanguage(_abstractLanguageId); AbstractsLanguage _abstractsLanguage = null; while (reader.Read()) { _abstractsLanguage = new AbstractsLanguage(); if (reader["AbstractLanguageId"] != DBNull.Value) { _abstractsLanguage.AbstractLanguageId = Convert.ToInt32(reader["AbstractLanguageId"]); } if (reader["AbstractId"] != DBNull.Value) { _abstractsLanguage.AbstractId = Convert.ToInt32(reader["AbstractId"]); } if (reader["AbstractTitle"] != DBNull.Value) { _abstractsLanguage.AbstractTitle = Convert.ToString(reader["AbstractTitle"]); } if (reader["AbstractIntro"] != DBNull.Value) { _abstractsLanguage.AbstractIntro = Convert.ToString(reader["AbstractIntro"]); } if (reader["CoverLetter"] != DBNull.Value) { _abstractsLanguage.CoverLetter = Convert.ToString(reader["CoverLetter"]); } if (reader["Topic"] != DBNull.Value) { _abstractsLanguage.Topic = Convert.ToString(reader["Topic"]); } if (reader["Background"] != DBNull.Value) { _abstractsLanguage.Background = Convert.ToString(reader["Background"]); } if (reader["Methods"] != DBNull.Value) { _abstractsLanguage.Methods = Convert.ToString(reader["Methods"]); } if (reader["Results"] != DBNull.Value) { _abstractsLanguage.Results = Convert.ToString(reader["Results"]); } if (reader["Conclusions"] != DBNull.Value) { _abstractsLanguage.Conclusions = Convert.ToString(reader["Conclusions"]); } if (reader["AbstractTerms"] != DBNull.Value) { _abstractsLanguage.AbstractTerms = Convert.ToString(reader["AbstractTerms"]); } if (reader["AbstractKeywords"] != DBNull.Value) { _abstractsLanguage.AbstractKeywords = Convert.ToString(reader["AbstractKeywords"]); } if (reader["LanguageID"] != DBNull.Value) { _abstractsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } _abstractsLanguage.NewRecord = false; } reader.Close(); return(_abstractsLanguage); }
public List <AbstractsLanguage> GetAll() { AbstractsLanguageDAC _abstractsLanguageComponent = new AbstractsLanguageDAC(); IDataReader reader = _abstractsLanguageComponent.GetAllAbstractsLanguage().CreateDataReader(); List <AbstractsLanguage> _abstractsLanguageList = new List <AbstractsLanguage>(); while (reader.Read()) { if (_abstractsLanguageList == null) { _abstractsLanguageList = new List <AbstractsLanguage>(); } AbstractsLanguage _abstractsLanguage = new AbstractsLanguage(); if (reader["AbstractLanguageId"] != DBNull.Value) { _abstractsLanguage.AbstractLanguageId = Convert.ToInt32(reader["AbstractLanguageId"]); } if (reader["AbstractId"] != DBNull.Value) { _abstractsLanguage.AbstractId = Convert.ToInt32(reader["AbstractId"]); } if (reader["AbstractTitle"] != DBNull.Value) { _abstractsLanguage.AbstractTitle = Convert.ToString(reader["AbstractTitle"]); } if (reader["AbstractIntro"] != DBNull.Value) { _abstractsLanguage.AbstractIntro = Convert.ToString(reader["AbstractIntro"]); } if (reader["CoverLetter"] != DBNull.Value) { _abstractsLanguage.CoverLetter = Convert.ToString(reader["CoverLetter"]); } if (reader["Topic"] != DBNull.Value) { _abstractsLanguage.Topic = Convert.ToString(reader["Topic"]); } if (reader["Background"] != DBNull.Value) { _abstractsLanguage.Background = Convert.ToString(reader["Background"]); } if (reader["Methods"] != DBNull.Value) { _abstractsLanguage.Methods = Convert.ToString(reader["Methods"]); } if (reader["Results"] != DBNull.Value) { _abstractsLanguage.Results = Convert.ToString(reader["Results"]); } if (reader["Conclusions"] != DBNull.Value) { _abstractsLanguage.Conclusions = Convert.ToString(reader["Conclusions"]); } if (reader["AbstractTerms"] != DBNull.Value) { _abstractsLanguage.AbstractTerms = Convert.ToString(reader["AbstractTerms"]); } if (reader["AbstractKeywords"] != DBNull.Value) { _abstractsLanguage.AbstractKeywords = Convert.ToString(reader["AbstractKeywords"]); } if (reader["LanguageID"] != DBNull.Value) { _abstractsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } _abstractsLanguage.NewRecord = false; _abstractsLanguageList.Add(_abstractsLanguage); } reader.Close(); return(_abstractsLanguageList); }
public bool Update(AbstractsLanguage abstractslanguage, int old_abstractLanguageId) { AbstractsLanguageDAC abstractslanguageComponent = new AbstractsLanguageDAC(); return(abstractslanguageComponent.UpdateAbstractsLanguage(abstractslanguage.AbstractId, abstractslanguage.AbstractTitle, abstractslanguage.AbstractIntro, abstractslanguage.CoverLetter, abstractslanguage.Topic, abstractslanguage.Background, abstractslanguage.Methods, abstractslanguage.Results, abstractslanguage.Conclusions, abstractslanguage.AbstractTerms, abstractslanguage.AbstractKeywords, abstractslanguage.LanguageID, old_abstractLanguageId)); }