public static AnalyzeModel GetProp(IQueryable <Borrow> borrows, IBooksReopository repository)
{
List <string> names = new List <string>();
List <int> values = new List <int>();
List <AnalyzeItem> analyzeItems = new List <AnalyzeItem>();
IQueryable <Reader> Readers = repository.Readers;
foreach (Reader b in Readers.ToList())
{
var analyzeItem = new AnalyzeItem();
var val = borrows.Where(br => br.ReaderId == b.Id).Count();
analyzeItem.name = b.Name;
analyzeItem.value = val;
names.Add(b.Name);
values.Add(val);
analyzeItems.Add(analyzeItem);
}
AnalyzeModel Sum = new AnalyzeModel
{
Values = values,
Names = names,
AnalyzeItems = analyzeItems
};
return(Sum);
}
//提供读者分析数据源
public static object GetReaderAnalyze(IBooksReopository repository, int readerId)
{
List <string> names = new List <string>();
List <int> values = new List <int>();
List <AnalyzeItem> analyzeItems = new List <AnalyzeItem>();
IQueryable <Category> Categories = repository.Categories;
foreach (Category b in Categories)
{
var analyzeItem = new AnalyzeItem();
var val = repository.Borrows.Where(e => e.ReaderId == readerId && e.Book.CategoryId == b.Id).Count();
analyzeItem.name = b.Name;
analyzeItem.value = val;
names.Add(b.Name);
values.Add(val);
analyzeItems.Add(analyzeItem);
}
AnalyzeModel q = new AnalyzeModel
{
Values = values,
Names = names,
AnalyzeItems = analyzeItems
};
return(q);
}
public FineforCount(IBooksReopository repository)
{
this.repository = repository;
IQueryable <Borrow> borrowsSum = this.repository.Borrows.Where(br => br.DateShouldBeReturn < DateTime.Now);
IQueryable <Borrow> ToFine = this.repository.Borrows.Where(br => br.DateShouldBeReturn < DateTime.Now && br.ReturnTime == null);
IQueryable <Borrow> Fined = this.repository.Borrows.Where(br => br.DateShouldBeReturn < DateTime.Now && br.ReturnTime != null);
this.Sum = FineforCount.GetProp(borrowsSum, repository);
this.ToFine = FineforCount.GetProp(ToFine, repository);
this.Fined = FineforCount.GetProp(Fined, repository);
}
public ReaderController(IBooksReopository BookRepository, IOrderProcessor OrderProcessor, MailProcessor MailProcessor)
{
this.Bookrepository = BookRepository;
this.OrderProcessor = OrderProcessor;
this.MailProcessor = MailProcessor;
}
public NavController(IBooksReopository bookRepository)
{
this.repository = bookRepository;
}
public ReaderController(IBooksReopository bookRepository, IOrderProcessor proc)
{
this.repository = bookRepository;
this.orderProcessor = proc;
}
public CartController(IBooksReopository bookRespository, IOrderProcessor proc)
{
this.respository = bookRespository;
this.orderProcessor = proc;
}
public AdminController(IBooksReopository BookRepository, IOrderProcessor iorderProcessor)
{
this.repository = BookRepository;
this.iorderProcessor = iorderProcessor;
}
public BookController(IBooksReopository reopository, IOrderProcessor orderProcessor)
{
this.reopository = reopository;
this.orderProcessor = orderProcessor;
}
public ShelfController(IBooksReopository repo, IOrderProcessor Processor)
{
repository = repo;
borrowProcessor = Processor;
}
public static IEnumerable <SelectListItem> GetCategorySelectListItem(IBooksReopository repository)
{
return(repository.Categories.ToList().Select(c => new SelectListItem {
Value = c.Id.ToString(), Text = c.Name
}));
}
public NavController(IBooksReopository repository, IOrderProcessor borrowProcessor)
{
this.repository = repository;
this.borrowProcessor = borrowProcessor;
}
//提供罚款统计数据源
public static object GetFineCount(IBooksReopository repository)
{
FineforCount fc = new FineforCount(repository);
return(fc);
}
