public List<Travellanguage> GetAll(int ParentID)
{
TravellanguageDAC _travellanguageComponent = new TravellanguageDAC();
IDataReader reader = _travellanguageComponent.GetAllTravellanguage("ParentID=" + ParentID).CreateDataReader();
List<Travellanguage> _travellanguageList = new List<Travellanguage>();
while (reader.Read())
{
if (_travellanguageList == null)
_travellanguageList = new List<Travellanguage>();
Travellanguage _travellanguage = new Travellanguage();
if (reader["ID"] != DBNull.Value)
_travellanguage.ID = Convert.ToInt32(reader["ID"]);
if (reader["Name"] != DBNull.Value)
_travellanguage.Name = Convert.ToString(reader["Name"]);
if (reader["TransportationTypeID"] != DBNull.Value)
_travellanguage.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]);
if (reader["Description"] != DBNull.Value)
_travellanguage.Description = Convert.ToString(reader["Description"]);
if (reader["ParentID"] != DBNull.Value)
_travellanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
if (reader["LanguageID"] != DBNull.Value)
_travellanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
_travellanguage.NewRecord = false;
_travellanguageList.Add(_travellanguage);
} reader.Close();
return _travellanguageList;
}
public Travellanguage GetByID(int _iD)
{
TravellanguageDAC _travellanguageComponent = new TravellanguageDAC();
IDataReader reader = _travellanguageComponent.GetByIDTravellanguage(_iD);
Travellanguage _travellanguage = null;
while(reader.Read())
{
_travellanguage = new Travellanguage();
if(reader["ID"] != DBNull.Value)
_travellanguage.ID = Convert.ToInt32(reader["ID"]);
if(reader["Name"] != DBNull.Value)
_travellanguage.Name = Convert.ToString(reader["Name"]);
if(reader["TransportationTypeID"] != DBNull.Value)
_travellanguage.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]);
if(reader["Description"] != DBNull.Value)
_travellanguage.Description = Convert.ToString(reader["Description"]);
if(reader["ParentID"] != DBNull.Value)
_travellanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
if(reader["LanguageID"] != DBNull.Value)
_travellanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
_travellanguage.NewRecord = false; } reader.Close();
return _travellanguage;
}
public void Delete(int Original_ID)
{
TravellanguageDAC travellanguageComponent = new TravellanguageDAC();
travellanguageComponent.DeleteTravellanguage(Original_ID);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
TravellanguageDAC travellanguagecomponent = new TravellanguageDAC();
return travellanguagecomponent.UpdateDataset(dataset);
}
public bool Update( string Name, int TransportationTypeID, string Description, int ParentID, int LanguageID, int Original_ID)
{
TravellanguageDAC travellanguageComponent = new TravellanguageDAC();
return travellanguageComponent.UpdateTravellanguage( Name, TransportationTypeID, Description, ParentID, LanguageID, Original_ID);
}
public bool Update(Travellanguage travellanguage ,int old_iD)
{
TravellanguageDAC travellanguageComponent = new TravellanguageDAC();
return travellanguageComponent.UpdateTravellanguage( travellanguage.Name, travellanguage.TransportationTypeID, travellanguage.Description, travellanguage.ParentID, travellanguage.LanguageID, old_iD);
}
public bool Insert( string Name, int TransportationTypeID, string Description, int ParentID, int LanguageID)
{
TravellanguageDAC travellanguageComponent = new TravellanguageDAC();
int ID = 0;
return travellanguageComponent.InsertNewTravellanguage( ref ID, Name, TransportationTypeID, Description, ParentID, LanguageID);
}
public bool Insert(Travellanguage travellanguage)
{
int autonumber = 0;
TravellanguageDAC travellanguageComponent = new TravellanguageDAC();
bool endedSuccessfuly = travellanguageComponent.InsertNewTravellanguage( ref autonumber, travellanguage.Name, travellanguage.TransportationTypeID, travellanguage.Description, travellanguage.ParentID, travellanguage.LanguageID);
if(endedSuccessfuly)
{
travellanguage.ID = autonumber;
}
return endedSuccessfuly;
}