Пример #1
0
        public List <DueSummaryResponse> GetDueSummary(int reportType)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();
            var get = dueSummaryService.ExecuteProcedure("Exec DueSummary '" + CurrentSession.GetCurrentSession().FinancialYear + "','" + reportType + "'," + yearId + "");

            return(get);
        }
Пример #2
0
        public List <PartyPaymentResponse> DailyReceiveAndPayment(int customerOrSupplier, string fromDate, string toDate)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();
            // var date = fromDate.Date.Date.ToString("yyyy-MM-dd");
            var get = pService.ExecuteProcedure("Exec DailyReceiveAndPayment '" + customerOrSupplier + "','" + fromDate + "','" + toDate + "'").OrderByDescending(a => a.PostingDate).ToList();

            return(get);
        }
Пример #3
0
        public rptIndividualLedger_Result GetBalance(int ledgerId)
        {
            SqlParameter        param   = new SqlParameter("@ledgerId", ledgerId);
            List <SqlParameter> paramss = new List <SqlParameter>();

            paramss.Add(param);
            SqlParameter param2 = new SqlParameter("@yearId", CurrentSession.GetCurrentSession().FinancialYear);

            paramss.Add(param2);
            return(balanceService.ExecuteProcedure("EXEC GetBalance @ledgerId,@yearId", paramss).FirstOrDefault());
        }