public Dictionary <string, object> BindStatementExpView(JsonFields Data)
{
FAMSEntities context = new FAMSEntities();
try
{
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With <StatementOfExpView>()
.Execute("@Querytype", "@ReportType", "@FromDate", "@ToDate", "@CustomerAccount", "GetStatementOfExpenses_View", Data.ReportType, Data.FromDate, Data.ToDate, Data.CustomerAccount));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid(JsonFields Data)
{
FAMSEntities context = new FAMSEntities();
try
{
//var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With<StatementOfExpenses>().With<StatementOfExpenses1>().With<StatementOfExpenses2>().With<StatementOfExpenses3>().With<StatementOfExpenses4>()
// .Execute("@Querytype", "@CustomerAccount", "@FromDate", "@ToDate", "GetStatementOfExpenses", CustomerAccount, FromDate, ToDate));
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_DemoReport]").With <StatementOfExpenses3>().With <StatementOfExpenses4>().With <StatementOfExpenses5>()
.Execute("@Querytype", "@CustomerAccount", "@FromDate", "@ToDate", "@SeqNo", "GetStatementOfExpenses", Data.CustomerAccount, Data.FromDate, Data.ToDate, Data.SeqNo));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}