public bool Insert(string LookupName, string LookupFriendlyName)
{
LookupsDAC lookupsComponent = new LookupsDAC();
int LookupId = 0;
return(lookupsComponent.InsertNewLookups(ref LookupId, LookupName, LookupFriendlyName));
}
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 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 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 bool Update(string LookupName, string LookupFriendlyName, int Original_LookupId)
{
LookupsDAC lookupsComponent = new LookupsDAC();
return(lookupsComponent.UpdateLookups(LookupName, LookupFriendlyName, Original_LookupId));
}
public bool Update(Lookups lookups, int old_lookupId)
{
LookupsDAC lookupsComponent = new LookupsDAC();
return(lookupsComponent.UpdateLookups(lookups.LookupName, lookups.LookupFriendlyName, old_lookupId));
}
public int UpdateDataset(System.Data.DataSet dataset)
{
LookupsDAC lookupscomponent = new LookupsDAC();
return(lookupscomponent.UpdateDataset(dataset));
}
public void Delete(int Original_LookupId)
{
LookupsDAC lookupsComponent = new LookupsDAC();
lookupsComponent.DeleteLookups(Original_LookupId);
}
