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