public Dictionary<string, object> BindDefaultData(GridFields Data) { FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[SP_PortfolioAppraisal]").With<PageLoadData>() .Execute("@Querytype", "@CustomerAccount", "@GUserId", "GetDefault_PortfolioAppraisal", Data.CustomerAccountno, Dbsecurity.Decrypt(Data.UserID))); return results; } catch (Exception ex) { throw ex; } }
public Dictionary<string, object> BindGrid(GridFields Data) { try { FAMSEntities context = new FAMSEntities(); // var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo); // var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CapitalStatement]").With<CapitalStatementModel>().Execute("@QueryType", "@Fromdate", "@Todate", "BindMainGrid",fromdate,todate)); var results = Common.Getdata(context.MultipleResults("[dbo].[SP_PortfolioAppraisal]").With<PortfolioappraisalModel>().With<SumPortfolioappraisalModel>().With<cashportfolio>().With<PortfolioappraisalModel>().With<HDATE>().Execute("@QueryType", "@SeqNo", "@Fromdate", "@CustomerAccount", "GetPortfolioAppraisal", Data.pagecount, Data.Fromdate, Data.CustomerAccountno)); return results; // } catch (Exception ex) { throw ex; } }