public static TurnOverReportCollection GetTurnOverReportSpecial(AccountantEntity accountEntity, DateTime from, DateTime to) { EntityModelContainer context = GetContext(); TurnOverReportCollection result = new TurnOverReportCollection(); //Cheque Payments Pay var queryChequePaymentPay = context.ChequePayments.Where( i => i.PayerId == accountEntity.Id && i.PayDate >= from && i.PayDate <= to && i.Status == (int)ChequeStatus.Unkown ); foreach (var item in queryChequePaymentPay) { result.Add(new TurnOverReportItem() { PageNumber = item.PaymentDocument.DocumentSerial.ToString(), Date = item.PayDate, PageTitle = "بابت شماره برگه " + item.PaymentDocument.DocumentSerial + "به خاطر پرداخت چک", PageDescription = item.Description, Credit = 0, Debit = item.Value }); } return result; }
public static TurnOverReportCollection GetTurnOverReport(AccountantEntity accountEntity, DateTime from, DateTime to) { if (accountEntity.Id == 67) return GetTurnOverReportSpecial(accountEntity, from, to); EntityModelContainer context = GetContext(); TurnOverReportCollection result = new TurnOverReportCollection(); TurnOverReportItem[] chequePayment = GetTurnOverChequePayment(accountEntity, from, to); foreach (var item in chequePayment) result.Add(item); TurnOverReportItem[] moneyPayment = GetTurnOverMoneyPayment(accountEntity, from, to); foreach (var item in moneyPayment) result.Add(item); TurnOverReportItem[] chequeReception = GetTurnOverChequeReception(accountEntity, from, to); foreach (var item in chequeReception) result.Add(item); TurnOverReportItem[] moneyReception = GetTurnOverMoneyReception(accountEntity, from, to); foreach (var item in moneyReception) result.Add(item); TurnOverReportItem[] visit = GetTurnOverVisit(accountEntity, from, to); foreach (var item in visit) result.Add(item); TurnOverReportItem[] visitInsurance = GetTurnOverVisitInsurance(accountEntity, from, to); foreach (var item in visitInsurance) result.Add(item); return result; }