public void deleteLicense(int customerID)
{
using (var db = new LicensesDataConnection())
{
db.LicenseData.Where(ld => ld.CustomerID.Equals(customerID)).Delete();
}
}
public void updateLicense(LicenseData ld)
{
using (var db = new LicensesDataConnection())
{
db.Update(ld);
}
}
public void addLicense(LicenseData ld)
{
using (var db = new LicensesDataConnection())
{
db.Insert(ld);
}
}
public LicenseData getLicense(int customerID)
{
using (var db = new LicensesDataConnection())
{
var ld = (from l in db.LicenseData
where l.CustomerID == customerID
select l).FirstOrDefault();
return(ld);
}
}
public List <LicenseData> getLicensesAsList()
{
using (var db = new LicensesDataConnection())
{
var query = from l in db.LicenseData
orderby l.CustomerID ascending
select l;
return(query.ToList());
}
}
public List <LicenseData> getLicensesAsList(String customerNameFilter)
{
using (var db = new LicensesDataConnection())
{
var query = from l in db.LicenseData
where l.CustomerName.Contains(customerNameFilter)
orderby l.CustomerID ascending
select l;
return(query.ToList());
}
}
