public bool Insert(Lookups lookups)
{
int autonumber = 0;
LookupsDAC lookupsComponent = new LookupsDAC();
bool endedSuccessfuly = lookupsComponent.InsertNewLookups( ref autonumber, lookups.LookupName, lookups.LookupFriendlyName);
if(endedSuccessfuly)
{
lookups.LookupId = autonumber;
}
return endedSuccessfuly;
}
public Lookups GetByID(int _lookupId)
{
LookupsDAC _lookupsComponent = new LookupsDAC();
IDataReader reader = _lookupsComponent.GetByIDLookups(_lookupId);
Lookups _lookups = null;
while(reader.Read())
{
_lookups = new Lookups();
if(reader["LookupId"] != DBNull.Value)
_lookups.LookupId = Convert.ToInt32(reader["LookupId"]);
if(reader["LookupName"] != DBNull.Value)
_lookups.LookupName = Convert.ToString(reader["LookupName"]);
if(reader["LookupFriendlyName"] != DBNull.Value)
_lookups.LookupFriendlyName = Convert.ToString(reader["LookupFriendlyName"]);
_lookups.NewRecord = false; } reader.Close();
return _lookups;
}
public List<Lookups> GetAll()
{
LookupsDAC _lookupsComponent = new LookupsDAC();
IDataReader reader = _lookupsComponent.GetAllLookups().CreateDataReader();
List<Lookups> _lookupsList = new List<Lookups>();
while(reader.Read())
{
if(_lookupsList == null)
_lookupsList = new List<Lookups>();
Lookups _lookups = new Lookups();
if(reader["LookupId"] != DBNull.Value)
_lookups.LookupId = Convert.ToInt32(reader["LookupId"]);
if(reader["LookupName"] != DBNull.Value)
_lookups.LookupName = Convert.ToString(reader["LookupName"]);
if(reader["LookupFriendlyName"] != DBNull.Value)
_lookups.LookupFriendlyName = Convert.ToString(reader["LookupFriendlyName"]);
_lookups.NewRecord = false;
_lookupsList.Add(_lookups);
} reader.Close();
return _lookupsList;
}
public bool Update(Lookups lookups ,int old_lookupId)
{
LookupsDAC lookupsComponent = new LookupsDAC();
return lookupsComponent.UpdateLookups( lookups.LookupName, lookups.LookupFriendlyName, old_lookupId);
}
