public Dictionary <string, object> BindGrid(GridFields Data) { try { //var UserId = Dbsecurity.Decypt(Data.UserId); //var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo); var CustomerAccountNo = (Data.CustomerAccountNo); // string base64 = ""; // 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_StatementDividend]").With<StatementDividentModel>().With<DividendModel>().With<SDSum>().With<SumDividend>().With<HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo)); var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_StatementDividend]").With <StatementDividentModel>().With <SDSum>().With <HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo)); // MemoryStream MyMemoryStream = new MemoryStream(); //Root.Reports.Report report = new Root.Reports.Report(new PdfFormatter()); //FontDef fd = new FontDef(report, "Helvetica"); //FontProp fp = new FontPropMM(fd, 25); //Page page = new Page(report); //page.AddCB_MM(80, new RepString(fp, "Hello World!")); //RT.ViewPDF(report, "HelloWorld.pdf"); // base64 = Convert.ToBase64String(MyMemoryStream.ToArray()); return(results); // } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindViewGrid(GridFields Data) { try { var CustomerAccountNo = (Data.CustomerAccountNo); var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_StatementDividend]").With <BindViewGridAllFields>() .Execute("@QueryType", "@CustomerAccount", "@PageType", "@FromDate", "@ToDate", "@UserId", "BindViewGrid", CustomerAccountNo, Data.PageType, Data.fromdate, Data.todate, Data.UserId)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindDefaultData(GridFields Data) { FAMSEntities context = new FAMSEntities(); try { var UserId = Dbsecurity.Decrypt(Data.UserId); var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_StatementDividend]").With <PageLoadData>() .Execute("@Querytype", "@UserId", "@CustomerAccount", "GetDefault_StatemenetOfExpenses", UserId, Data.CustomerAccountNo)); return(results); } catch (Exception ex) { throw ex; } }