public ConferenceCategoryLanguage GetByID(int _conferenceCategoryId)
{
ConferenceCategoryLanguageDAC _conferenceCategoryLanguageComponent = new ConferenceCategoryLanguageDAC();
IDataReader reader = _conferenceCategoryLanguageComponent.GetByIDConferenceCategoryLanguage(_conferenceCategoryId);
ConferenceCategoryLanguage _conferenceCategoryLanguage = null;
while (reader.Read())
{
_conferenceCategoryLanguage = new ConferenceCategoryLanguage();
if (reader["ConferenceCategoryId"] != DBNull.Value)
{
_conferenceCategoryLanguage.ConferenceCategoryId = Convert.ToInt32(reader["ConferenceCategoryId"]);
}
if (reader["CategoryName"] != DBNull.Value)
{
_conferenceCategoryLanguage.CategoryName = Convert.ToString(reader["CategoryName"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_conferenceCategoryLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_conferenceCategoryLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ConferenceCategoryParentID"] != DBNull.Value)
{
_conferenceCategoryLanguage.ConferenceCategoryParentID = Convert.ToInt32(reader["ConferenceCategoryParentID"]);
}
_conferenceCategoryLanguage.NewRecord = false;
}
reader.Close();
return(_conferenceCategoryLanguage);
}
public bool Insert(ConferenceCategoryLanguage conferencecategorylanguage)
{
int autonumber = 0;
ConferenceCategoryLanguageDAC conferencecategorylanguageComponent = new ConferenceCategoryLanguageDAC();
bool endedSuccessfuly = conferencecategorylanguageComponent.InsertNewConferenceCategoryLanguage(ref autonumber, conferencecategorylanguage.CategoryName, conferencecategorylanguage.ConferenceId, conferencecategorylanguage.LanguageID, conferencecategorylanguage.ConferenceCategoryParentID);
if (endedSuccessfuly)
{
conferencecategorylanguage.ConferenceCategoryId = autonumber;
}
return(endedSuccessfuly);
}
public List <ConferenceCategoryLanguage> GetAll(int ParentID)
{
ConferenceCategoryLanguageDAC _conferenceCategoryLanguageComponent = new ConferenceCategoryLanguageDAC();
IDataReader reader = _conferenceCategoryLanguageComponent.GetAllConferenceCategoryLanguage("ConferenceCategoryParentID=" + ParentID).CreateDataReader();
List <ConferenceCategoryLanguage> _conferenceCategoryLanguageList = new List <ConferenceCategoryLanguage>();
while (reader.Read())
{
if (_conferenceCategoryLanguageList == null)
{
_conferenceCategoryLanguageList = new List <ConferenceCategoryLanguage>();
}
ConferenceCategoryLanguage _conferenceCategoryLanguage = new ConferenceCategoryLanguage();
if (reader["ConferenceCategoryId"] != DBNull.Value)
{
_conferenceCategoryLanguage.ConferenceCategoryId = Convert.ToInt32(reader["ConferenceCategoryId"]);
}
if (reader["CategoryName"] != DBNull.Value)
{
_conferenceCategoryLanguage.CategoryName = Convert.ToString(reader["CategoryName"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_conferenceCategoryLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_conferenceCategoryLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ConferenceCategoryParentID"] != DBNull.Value)
{
_conferenceCategoryLanguage.ConferenceCategoryParentID = Convert.ToInt32(reader["ConferenceCategoryParentID"]);
}
_conferenceCategoryLanguage.NewRecord = false;
_conferenceCategoryLanguageList.Add(_conferenceCategoryLanguage);
}
reader.Close();
return(_conferenceCategoryLanguageList);
}
public bool Update(ConferenceCategoryLanguage conferencecategorylanguage, int old_conferenceCategoryId)
{
ConferenceCategoryLanguageDAC conferencecategorylanguageComponent = new ConferenceCategoryLanguageDAC();
return(conferencecategorylanguageComponent.UpdateConferenceCategoryLanguage(conferencecategorylanguage.CategoryName, conferencecategorylanguage.ConferenceId, conferencecategorylanguage.LanguageID, conferencecategorylanguage.ConferenceCategoryParentID, old_conferenceCategoryId));
}
