private Company FindFirstCompany(string company1)
{
if (findFirstCompanyQuery == null)
{
Expression <Func <ErpContext, string, Company> > expression =
(ctx, company1_ex) =>
(from row in ctx.Company
where row.Company1 == company1_ex
select row).FirstOrDefault();
findFirstCompanyQuery = DBExpressionCompiler.Compile(expression);
}
return(findFirstCompanyQuery(this.Db, company1));
}
private BankAcct FindFirstBankAcct(string company, string bankAcctID)
{
if (findFirstBankAcctQuery == null)
{
Expression <Func <ErpContext, string, string, BankAcct> > expression =
(ctx, company_ex, bankAcctID_ex) =>
(from row in ctx.BankAcct
where row.Company == company_ex &&
row.BankAcctID == bankAcctID_ex
select row).FirstOrDefault();
findFirstBankAcctQuery = DBExpressionCompiler.Compile(expression);
}
return(findFirstBankAcctQuery(this.Db, company, bankAcctID));
}
private Currency FindFirstCurrency(string company, string currCode)
{
if (findFirstCurrencyQuery2 == null)
{
Expression <Func <ErpContext, string, string, Currency> > expression =
(ctx, company_ex, CurrCode_ex) =>
(from row in ctx.Currency
where row.Company == company_ex &&
row.CurrencyCode == CurrCode_ex
select row).FirstOrDefault();
findFirstCurrencyQuery2 = DBExpressionCompiler.Compile(expression);
}
return(findFirstCurrencyQuery2(this.Db, company, currCode));
}
private Currency FindFirstCurrency(string company, bool baseCurr)
{
if (findFirstCurrencyQuery == null)
{
Expression <Func <ErpContext, string, bool, Currency> > expression =
(ctx, company_ex, baseCurr_ex) =>
(from row in ctx.Currency
where row.Company == company_ex &&
row.BaseCurr == baseCurr_ex
select row).FirstOrDefault();
findFirstCurrencyQuery = DBExpressionCompiler.Compile(expression);
}
return(findFirstCurrencyQuery(this.Db, company, baseCurr));
}
private Country FindFirstCountry3(string company, int countryNum)
{
if (findFirstCountry3Query == null)
{
Expression <Func <ErpContext, string, int, Country> > expression =
(ctx, company_ex, countryNum_ex) =>
(from row in ctx.Country
where row.Company == company_ex &&
row.CountryNum == countryNum_ex
select row).FirstOrDefault();
findFirstCountry3Query = DBExpressionCompiler.Compile(expression);
}
return(findFirstCountry3Query(this.Db, company, countryNum));
}
private IEnumerable <APTran> SelectAPTran(string company, int headNum)
{
if (selectAPTranQuery == null)
{
Expression <Func <ErpContext, string, int, IEnumerable <APTran> > > expression =
(ctx, company_ex, headNum_ex) =>
(from row in ctx.APTran
where row.Company == company_ex &&
row.HeadNum == headNum_ex
orderby row.Company, row.HeadNum, row.APTranNo, row.InvoiceNum
select row);
selectAPTranQuery = DBExpressionCompiler.Compile(expression);
}
return(selectAPTranQuery(this.Db, company, headNum));
}
private VendBank FindFirstVendBank(string company, int vendorNum, string bankID)
{
if (findFirstVendBankQuery == null)
{
Expression <Func <ErpContext, string, int, string, VendBank> > expression =
(ctx, company_ex, vendorNum_ex, bankID_ex) =>
(from row in ctx.VendBank
where row.Company == company_ex &&
row.VendorNum == vendorNum_ex &&
row.BankID == bankID_ex
select row).FirstOrDefault();
findFirstVendBankQuery = DBExpressionCompiler.Compile(expression);
}
return(findFirstVendBankQuery(this.Db, company, vendorNum, bankID));
}