public List <CustomerDatastatistics> GetReportData()
{
customerContactRepo = RepositoryHelper.Get客戶聯絡人Repository();
customerDataRepo = RepositoryHelper.Get客戶資料Repository();
customerBankRepo = RepositoryHelper.Get客戶銀行資訊Repository();
var customerDatas = customerDataRepo.All().Select(
c =>
new CustomerDatastatistics
{
ID = c.Id,
客戶名稱 = c.客戶名稱,
}).ToList();
foreach (var a in customerDatas)
{
var customerContactDatas = customerContactRepo.All().Where(c => c.客戶Id == a.ID).Count();
var customerBankDatas = customerBankRepo.All().Where(c => c.客戶Id == a.ID).Count();
a.聯絡人數量 = customerContactDatas;
a.銀行帳戶數量 = customerBankDatas;
}
return(customerDatas);
}
public List <客戶聯絡人> AllData()
{
客戶聯絡人Repository customerContactRepo = RepositoryHelper.Get客戶聯絡人Repository();
var customerData = RepositoryHelper.Get客戶資料Repository().All().ToList();
var customerContact = customerContactRepo.All().ToList()
.Join(customerData, a => a.客戶Id, b => b.Id, (a, b) => new 客戶聯絡人
{
Id = a.Id,
客戶Id = a.客戶Id,
職稱 = a.職稱,
姓名 = a.姓名,
Email = a.Email,
手機 = a.手機,
電話 = a.電話,
是否已刪除 = a.是否已刪除,
客戶資料 = new 客戶資料 {
Id = a.客戶Id, 客戶名稱 = b.客戶名稱
}
}).Where(c => c.是否已刪除 == false).ToList();
return(customerContact);
}