public static List <ReconcilationReport> GetReconcilation(string clientBin, string contractNumber, DateTime startDate, DateTime endDate)
{
List <ReconcilationReport> reconcilationReport = new List <ReconcilationReport>();
RRSelection rRSelection = new RRSelection();
rRSelection.ClientIIN = clientBin;
//rRSelection.ContractName = contractNumber;
//rRSelection.EndDate = endDate;
//rRSelection.StartDate = startDate;
var reconcilationReportRows = baseConn.getReconciliationReport(rRSelection);
if (reconcilationReportRows != null)
{
foreach (var item in reconcilationReportRows)
{
reconcilationReport.Add(new ReconcilationReport()
{
clientName = item.Client,
contractNum = item.Contract,
credit = (decimal)item.Credit,
debit = (decimal)item.Debit,
docDate = item.DocDate,
docName = item.DocName,
currency = item.Сurrency,
});
}
return(reconcilationReport);
}
else
{
return(null);
}
}
public static List <DebtorReport> GetDebtors(int baseType, DateTime startDate, DateTime endDate, string[] clientBins)
{
AppJournal.Write("1C Transport", "Get debtors", true);
ChooseBaseType(baseType);
RRSelection rRSelection = new RRSelection();
List <DebtorReport> debtorReport = new List <DebtorReport>();
rRSelection.StartDate = startDate;
rRSelection.EndDate = endDate;
foreach (var item in clientBins)
{
rRSelection.ClientIIN = item;
var reconcilationReportRows = baseConn.getDebitorsReport(rRSelection);
if (reconcilationReportRows != null)
{
foreach (var subItem in reconcilationReportRows)
{
if (subItem.Credit != subItem.Debit)
{
debtorReport.Add(new DebtorReport()
{
clientBIN = subItem.Client,
credit = Convert.ToDecimal(subItem.Credit) > Convert.ToDecimal(subItem.Debit) ? Convert.ToDecimal(subItem.Credit) - Convert.ToDecimal(subItem.Debit) : 0,
debit = Convert.ToDecimal(subItem.Debit) > Convert.ToDecimal(subItem.Credit) ? Convert.ToDecimal(subItem.Debit) - Convert.ToDecimal(subItem.Credit) : 0,
result = Convert.ToDecimal(subItem.Debit) - Convert.ToDecimal(subItem.Credit),
brokerName = baseType == 1 ? "ТОО Альта и К" : baseType == 2 ? "Корунд-777" : "Ак Алтын Ко",
balance = (Convert.ToDecimal(subItem.Debit) - Convert.ToDecimal(subItem.Credit)) > 0 ? true : false
});
}
}
}
}
return(debtorReport);
}
