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)); }