public List <PartyPaymentResponse> GetAllInvoice(int ledgerId, int customerOrSupplier) { List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter param = new SqlParameter("@LedgerId", ledgerId); parameters.Add(param); var get = pService.ExecuteProcedure("Exec DailyTransaction '" + ledgerId + "','" + customerOrSupplier + "','" + yearId + "'"); return(get); }
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 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()); }
public DataTable GetIncomeStatement(DateTime fromDate, DateTime toDate) { List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter param1 = new SqlParameter("@fromDate", DateTime.Now.AddMonths(-1)); parameters.Add(param1); SqlParameter param2 = new SqlParameter("@toDate", DateTime.Now); parameters.Add(param2); var get = service.ExecuteProcedure("Exec StockOutChallanList @fromDate,@toDate", parameters, true); return(get); }
public List <TopSellResponse> GetTopSell() { //var result = (from i in entity.SalesDetails // group i by i.ProductId into g // select new TopSellResponse() // { // ItemId = g.Key, // ProductName = g.Where(a => a.ProductId == g.Key).FirstOrDefault().Product.ProductName, // }).ToList().OrderByDescending(a => a.SalesQty); DataTable dt = null; dt = oResult.Data as DataTable; return(topSellResponse.ExecuteProcedure("ProductWiseBestSales")); }