public TransportationTypeLanguage GetByTransportationTypeIDandLanguageId(int ParentID, int LanguageID)
{
TransportationTypeLanguageDAC _transportationTypeLanguageComponent = new TransportationTypeLanguageDAC();
IDataReader reader = _transportationTypeLanguageComponent.GetAllTransportationTypeLanguage(string.Format("ParentID={0} and LanguageID={1}", ParentID, LanguageID)).CreateDataReader();
TransportationTypeLanguage _transportationTypeLanguage = new TransportationTypeLanguage();
while (reader.Read())
{
if (reader["ID"] != DBNull.Value)
{
_transportationTypeLanguage.ID = Convert.ToInt32(reader["ID"]);
}
if (reader["TypeName"] != DBNull.Value)
{
_transportationTypeLanguage.TypeName = Convert.ToString(reader["TypeName"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_transportationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ParentID"] != DBNull.Value)
{
_transportationTypeLanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
}
_transportationTypeLanguage.NewRecord = false;
}
reader.Close();
return(_transportationTypeLanguage);
}
public List <TransportationTypeLanguage> GetAll(int ParentID)
{
TransportationTypeLanguageDAC _transportationTypeLanguageComponent = new TransportationTypeLanguageDAC();
IDataReader reader = _transportationTypeLanguageComponent.GetAllTransportationTypeLanguage("ParentID=" + ParentID).CreateDataReader();
List <TransportationTypeLanguage> _transportationTypeLanguageList = new List <TransportationTypeLanguage>();
while (reader.Read())
{
if (_transportationTypeLanguageList == null)
{
_transportationTypeLanguageList = new List <TransportationTypeLanguage>();
}
TransportationTypeLanguage _transportationTypeLanguage = new TransportationTypeLanguage();
if (reader["ID"] != DBNull.Value)
{
_transportationTypeLanguage.ID = Convert.ToInt32(reader["ID"]);
}
if (reader["TypeName"] != DBNull.Value)
{
_transportationTypeLanguage.TypeName = Convert.ToString(reader["TypeName"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_transportationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ParentID"] != DBNull.Value)
{
_transportationTypeLanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
}
_transportationTypeLanguage.NewRecord = false;
_transportationTypeLanguageList.Add(_transportationTypeLanguage);
}
reader.Close();
return(_transportationTypeLanguageList);
}
public TransportationTypeLanguage GetByID(int _iD)
{
TransportationTypeLanguageDAC _transportationTypeLanguageComponent = new TransportationTypeLanguageDAC();
IDataReader reader = _transportationTypeLanguageComponent.GetByIDTransportationTypeLanguage(_iD);
TransportationTypeLanguage _transportationTypeLanguage = null;
while (reader.Read())
{
_transportationTypeLanguage = new TransportationTypeLanguage();
if (reader["ID"] != DBNull.Value)
{
_transportationTypeLanguage.ID = Convert.ToInt32(reader["ID"]);
}
if (reader["TypeName"] != DBNull.Value)
{
_transportationTypeLanguage.TypeName = Convert.ToString(reader["TypeName"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_transportationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ParentID"] != DBNull.Value)
{
_transportationTypeLanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
}
_transportationTypeLanguage.NewRecord = false;
}
reader.Close();
return(_transportationTypeLanguage);
}
public bool Insert(string TypeName, int LanguageID, int ParentID)
{
TransportationTypeLanguageDAC transportationtypelanguageComponent = new TransportationTypeLanguageDAC();
int ID = 0;
return(transportationtypelanguageComponent.InsertNewTransportationTypeLanguage(ref ID, TypeName, LanguageID, ParentID));
}
public bool Insert(TransportationTypeLanguage transportationtypelanguage)
{
int autonumber = 0;
TransportationTypeLanguageDAC transportationtypelanguageComponent = new TransportationTypeLanguageDAC();
bool endedSuccessfuly = transportationtypelanguageComponent.InsertNewTransportationTypeLanguage(ref autonumber, transportationtypelanguage.TypeName, transportationtypelanguage.LanguageID, transportationtypelanguage.ParentID);
if (endedSuccessfuly)
{
transportationtypelanguage.ID = autonumber;
}
return(endedSuccessfuly);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
TransportationTypeLanguageDAC transportationtypelanguagecomponent = new TransportationTypeLanguageDAC();
return(transportationtypelanguagecomponent.UpdateDataset(dataset));
}
public void Delete(int Original_ID)
{
TransportationTypeLanguageDAC transportationtypelanguageComponent = new TransportationTypeLanguageDAC();
transportationtypelanguageComponent.DeleteTransportationTypeLanguage(Original_ID);
}
public bool Update(string TypeName, int LanguageID, int ParentID, int Original_ID)
{
TransportationTypeLanguageDAC transportationtypelanguageComponent = new TransportationTypeLanguageDAC();
return(transportationtypelanguageComponent.UpdateTransportationTypeLanguage(TypeName, LanguageID, ParentID, Original_ID));
}
public bool Update(TransportationTypeLanguage transportationtypelanguage, int old_iD)
{
TransportationTypeLanguageDAC transportationtypelanguageComponent = new TransportationTypeLanguageDAC();
return(transportationtypelanguageComponent.UpdateTransportationTypeLanguage(transportationtypelanguage.TypeName, transportationtypelanguage.LanguageID, transportationtypelanguage.ParentID, old_iD));
}
