public ResearchChairLanguages GetByID(int _researchChairLanguagesId)
{
ResearchChairLanguagesDAC _researchChairLanguagesComponent = new ResearchChairLanguagesDAC();
IDataReader reader = _researchChairLanguagesComponent.GetByIDResearchChairLanguages(_researchChairLanguagesId);
ResearchChairLanguages _researchChairLanguages = null;
while (reader.Read())
{
_researchChairLanguages = new ResearchChairLanguages();
if (reader["ResearchChairLanguagesId"] != DBNull.Value)
{
_researchChairLanguages.ResearchChairLanguagesId = Convert.ToInt32(reader["ResearchChairLanguagesId"]);
}
if (reader["ResearchChairId"] != DBNull.Value)
{
_researchChairLanguages.ResearchChairId = Convert.ToInt32(reader["ResearchChairId"]);
}
if (reader["LanguageId"] != DBNull.Value)
{
_researchChairLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["Name"] != DBNull.Value)
{
_researchChairLanguages.Name = Convert.ToString(reader["Name"]);
}
if (reader["Description"] != DBNull.Value)
{
_researchChairLanguages.Description = Convert.ToString(reader["Description"]);
}
_researchChairLanguages.NewRecord = false;
}
reader.Close();
return(_researchChairLanguages);
}
public bool Insert(ResearchChairLanguages researchchairlanguages)
{
int autonumber = 0;
ResearchChairLanguagesDAC researchchairlanguagesComponent = new ResearchChairLanguagesDAC();
bool endedSuccessfuly = researchchairlanguagesComponent.InsertNewResearchChairLanguages(ref autonumber, researchchairlanguages.ResearchChairId, researchchairlanguages.LanguageId, researchchairlanguages.Name, researchchairlanguages.Description);
if (endedSuccessfuly)
{
researchchairlanguages.ResearchChairLanguagesId = autonumber;
}
return(endedSuccessfuly);
}
public List <ResearchChairLanguages> GetAll()
{
ResearchChairLanguagesDAC _researchChairLanguagesComponent = new ResearchChairLanguagesDAC();
IDataReader reader = _researchChairLanguagesComponent.GetAllResearchChairLanguages().CreateDataReader();
List <ResearchChairLanguages> _researchChairLanguagesList = new List <ResearchChairLanguages>();
while (reader.Read())
{
if (_researchChairLanguagesList == null)
{
_researchChairLanguagesList = new List <ResearchChairLanguages>();
}
ResearchChairLanguages _researchChairLanguages = new ResearchChairLanguages();
if (reader["ResearchChairLanguagesId"] != DBNull.Value)
{
_researchChairLanguages.ResearchChairLanguagesId = Convert.ToInt32(reader["ResearchChairLanguagesId"]);
}
if (reader["ResearchChairId"] != DBNull.Value)
{
_researchChairLanguages.ResearchChairId = Convert.ToInt32(reader["ResearchChairId"]);
}
if (reader["LanguageId"] != DBNull.Value)
{
_researchChairLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["Name"] != DBNull.Value)
{
_researchChairLanguages.Name = Convert.ToString(reader["Name"]);
}
if (reader["Description"] != DBNull.Value)
{
_researchChairLanguages.Description = Convert.ToString(reader["Description"]);
}
_researchChairLanguages.NewRecord = false;
_researchChairLanguagesList.Add(_researchChairLanguages);
}
reader.Close();
return(_researchChairLanguagesList);
}
public bool Update(ResearchChairLanguages researchchairlanguages, int old_researchChairLanguagesId)
{
ResearchChairLanguagesDAC researchchairlanguagesComponent = new ResearchChairLanguagesDAC();
return(researchchairlanguagesComponent.UpdateResearchChairLanguages(researchchairlanguages.ResearchChairId, researchchairlanguages.LanguageId, researchchairlanguages.Name, researchchairlanguages.Description, old_researchChairLanguagesId));
}
