//BindGridOncustomerChange
public Dictionary <string, object> BindGridOncustomerChange(JsonFields Data)
{
FAMSEntities context = new FAMSEntities();
try
{
//var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CurrentPortfolio]").With<GridFieldData>().With<Header>().With<GridTotalFieldData>().With<NextGrid>()
// .Execute("@Querytype", "@ReportDate", "@CustomerAccount", "@PageCount", "BindGrid", Data.ReportDate, Data.CustomerAccountNo, Data.PageCount));
//var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CurrentPortfolio]").With<GridFieldDataView>().Execute("@Querytype", "@ReportDate", "@CustomerAccount", "@PageCount", "@ReportType", "BindGridView", Data.ReportDate, Data.CustomerAccountNo, Data.PageCount,Data.ReportType));
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CurrentPortfolio]").With <GridFieldDataView>().Execute("@Querytype", "@ReportDate", "@CustomerAccount", "@PageCount", "@ReportType", "BindChangeCustomerAccount", Data.ReportDate, Data.CustomerAccountNo, Data.PageCount, Data.ReportType));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid(JsonFields Data)
{
FAMSEntities context = new FAMSEntities();
try
{
// var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo);
//var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CurrentPortfolio]").With<GridFieldData>().With<GridTotalFieldData>().With<GridTotalFieldData>().With<GridFieldData>()
// .Execute("@Querytype", "@Fromdate", "@Todate", "@CustomerAccount", "BindGrid", Data.FromDate, Data.ToDate, CustomerAccountNo));
//return results;
var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CurrentPortfolio]").With <GridFieldData>().With <Header>().With <GridTotalFieldData>().With <NextGrid>()
.Execute("@Querytype", "@ReportDate", "@CustomerAccount", "@PageCount", "BindGrid", Data.ReportDate, Data.CustomerAccountNo, Data.PageCount));
return(results);
}
catch (Exception ex)
{
throw ex;
}
}
