public Dictionary <string, object> BindEmployees(GridFields Data) { ///FAMSEntities context = new FAMSEntities(); try { var results = Common.Getdata(context.MultipleResults("[dbo].[Sp_CapitalStatement]").With <BindEmployees>() .Execute("@Querytype", "@UserId", "BindEmployees", Dbsecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Data.UserId.Replace("_", "%"))))); 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_CapitalStatement]").With <PageLoadData>() .Execute("@Querytype", "@UserId", "@CustomerAccount", "GetDefault_StatemenetOfExpenses", UserId, Data.CustomerAccountNo)); return(results); } catch (Exception ex) { throw ex; } }
public Dictionary <string, object> BindGrid(GridFields Data) { try { //var UserId = Dbsecurity.Decypt(Data.UserId); HDATE //var CustomerAccountNo = Dbsecurity.Decrypt(Data.CustomerAccountNo); var CustomerAccountNo = (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_CapitalStatement]").With <CapitalStatementModel>().With <CSSum>().With <HDATE>().Execute("@QueryType", "@PageCount", "@Fromdate", "@Todate", "@CustomerAccount", "BindMainGrid", Data.PageCount, Data.fromdate, Data.todate, CustomerAccountNo)); return(results); // } catch (Exception ex) { throw ex; } }