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