예제 #1
0
 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;
 }
예제 #2
0
 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;
 }
예제 #3
0
 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);
 }
예제 #4
0
 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;
 }