private void LoadAccount(int companyID, int fundID, int departmentID, int accountID, DateTime startDate)
{
if (companyID <= 0)
{
throw new ArgumentNullException("Company ID", "Company ID is required.");
}
if (fundID <= 0)
{
throw new ArgumentNullException("Fund ID", "Fund ID is required.");
}
if (departmentID <= 0)
{
throw new ArgumentNullException("Department ID", "Department ID is required.");
}
if (accountID <= 0)
{
throw new ArgumentNullException("Account ID", "Account ID is required.");
}
if (startDate == DateTime.MinValue)
{
throw new ArgumentNullException("Start Date", "Start Date is required.");
}
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
var accountData = Context.GLAccountDatas
.Where(a => a.CompanyNumber == companyID)
.Where(a => a.FundNumber == fundID)
.Where(a => a.DepartmentNumber == departmentID)
.Where(a => a.AccountNumber == accountID)
.Where(a => a.BeginDate == startDate)
.FirstOrDefault();
Load(accountData);
}
}
public static List <Fund> GetFunds()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLFundDatas
.Select(f => new Fund(f))
.ToList());
}
}
public static List <Company> GetCompanies()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLCompanyDatas
.Select(c => new Company(c))
.ToList());
}
}
public static List <FiscalYear> GetFiscalYears()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLYearDatas
.Select(y => new FiscalYear(y))
.ToList());
}
}
public static List <Department> LoadDepartments()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLDepartmentDatas
.Select(d => new Department(d))
.ToList());
}
}
public static List <Fund> GetFundByCompany(int companyID)
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLFundDatas
.Where(f => f.CompanyNumber == companyID)
.Select(f => new Fund(f))
.ToList());
}
}
private Company GetCompany()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(new Company(Context.GLFundDatas
.Where(f => f.CompanyNumber == CompanyID)
.Where(f => f.FundNumber == FundID)
.FirstOrDefault().GLCompanyData));
}
}
private List <Department> GetDepartments()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLCompanyDatas
.Where(c => c.CompanyNumber == mCompanyID)
.FirstOrDefault()
.GLDepartmentDatas
.Select(d => new Department(d))
.ToList());
}
}
private List <Account> GetAccounts()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLCompanyDatas
.Where(c => c.CompanyNumber == mCompanyID)
.FirstOrDefault()
.GLAccountDatas
.Select(a => new Account(a))
.ToList());
}
}
private List <FiscalYear> GetFiscalYears()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLCompanyDatas
.Where(x => x.CompanyNumber == mCompanyID)
.FirstOrDefault()
.GLYearDatas
.Select(y => new FiscalYear(y))
.ToList());
}
}
private void LoadDepartment(int companyID, int fundID, int departmentID)
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
var DepartmentData = Context.GLDepartmentDatas
.Where(d => d.CompanyNumber == companyID)
.Where(d => d.FundNumber == fundID)
.Where(d => d.DepartmentNumber == departmentID)
.FirstOrDefault();
Load(DepartmentData);
}
}
private void LoadByID(int id)
{
if (id <= 0)
{
throw new ArgumentNullException("ID", "Company ID is required.");
}
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
Load(Context.GLCompanyDatas.FirstOrDefault(c => c.CompanyNumber == id));
}
}
private List <Fund> GetFunds()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLCompanyDatas
.Where(c => c.CompanyNumber == mCompanyID)
.FirstOrDefault()
.GLFundDatas
.Select(f => new Fund(f))
.ToList());
}
}
private void LoadByCompanyStartDate(int companyID, DateTime startDate)
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
var fiscalYear = Context.GLYearDatas
.Where(y => y.CompanyNumber == companyID)
.Where(y => y.BeginDate == startDate)
.FirstOrDefault();
Load(fiscalYear);
}
}
private Fund GetFund()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
var fundData = Context.GLDepartmentDatas
.Where(c => c.CompanyNumber == mCompanyID)
.Where(c => c.FundNumber == mFundID)
.Where(c => c.DepartmentNumber == mDepartmentID)
.FirstOrDefault()
.GLFundData;
return(new Fund(fundData));
}
}
private List <Account> GetAccounts()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLDepartmentDatas
.Where(d => d.CompanyNumber == mCompanyID)
.Where(d => d.FundNumber == mFundID)
.Where(d => d.DepartmentNumber == mDepartmentID)
.FirstOrDefault()
.GLAccountDatas
.Select(a => new Account(a))
.ToList());
}
}
public static List <FiscalYear> GetFiscalYearsByCompany(int companyID)
{
if (companyID <= 0)
{
throw new ArgumentNullException("CompanyID", "Company ID is required.");
}
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLYearDatas
.Where(y => y.CompanyNumber == companyID)
.Select(y => new FiscalYear(y))
.ToList());
}
}
private List <Account> GetAccounts()
{
List <Account> Accounts = new List <Account>();
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLFundDatas
.Where(f => f.CompanyNumber == CompanyID)
.Where(f => f.FundNumber == FundID)
.FirstOrDefault()
.GLAccountDatas
.Select(a => new Account(a))
.ToList());
}
}
private List <Department> GetDepartments()
{
List <Department> Departments = new List <Department>();
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLFundDatas
.Where(f => f.CompanyNumber == CompanyID)
.Where(f => f.FundNumber == FundID)
.FirstOrDefault()
.GLDepartmentDatas
.Select(d => new Department(d))
.ToList());
}
}
private static List <Department> LoadDepartmentsByCompany(int companyID)
{
if (companyID <= 0)
{
throw new ArgumentNullException("companyID", "Company ID is required");
}
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
return(Context.GLDepartmentDatas
.Where(d => d.CompanyNumber == companyID)
.Select(d => new Department(d))
.ToList());
}
}
private Department GetDepartment()
{
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
var departmentData = Context.GLAccountDatas
.Where(a => a.CompanyNumber == CompanyID)
.Where(a => a.FundNumber == FundID)
.Where(a => a.DepartmentNumber == DepartmentID)
.Where(a => a.AccountNumber == AccountID)
.Where(a => a.BeginDate == StartDate)
.FirstOrDefault()
.GLDepartmentData;
return(new Department(departmentData));
}
}
private void LoadByCompanyFund(int companyId, int fundID)
{
if (companyId <= 0)
{
throw new ArgumentNullException("CompanyID", "Company ID is required.");
}
if (fundID <= 0)
{
throw new ArgumentNullException("FundID", "Fund ID is required.");
}
using (ShelbyContext Context = ContextHelper.GetShelbyContext())
{
var fundData = Context.GLFundDatas
.Where(f => f.CompanyNumber == companyId)
.Where(f => f.FundNumber == fundID)
.FirstOrDefault();
Load(fundData);
}
}
