Company ICRUDCompany.GetCompany(string companyname)
{
Company company = new Company();
var context = new PayohteeDbContext(options: new DbContextOptions <PayohteeDbContext>());
return(null);
}
/// <summary>
/// Get Company List (Suggestive)
/// </summary>
/// <value>
/// Value comes from UI input and wildcard search on all elements in list
/// </value>
public List <string> GetAsyncListCompanyName(string c)
{
var context = new PayohteeDbContext(options: new DbContextOptions <PayohteeDbContext>());
List <string> list = (from a in context.DbContextCompany.Where(x => x.CompanyName.Contains(c))
select a.CompanyName).ToList();
return(list);
}
public void GetEmployeePayRate(Employee employee)
{
var payrate = new PayRate();
var context = new PayohteeDbContext(null);
try
{
//var employeeresult = context.DbContextCustomsOfficers.Find(employee.EmployeeId);
//if (employeeresult == null)
//{
// this.PayRate = 0;
//}
//else
//{
// var rateresult = context.DbContextCustomsRate.Where(x => x.RateCode == employeeresult.RateCode).Single();
// this.PayRate = rateresult.RateAmount;
//}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public void GetCompany(string companyname)
{
var context = new PayohteeDbContext(options: new DbContextOptions <PayohteeDbContext>());
List <string> list = (from a in context.DbContextCompany.Where(x => x.CompanyName.Contains(companyname))
select a.CompanyName).ToList();
}