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); }
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); }
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()); }