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