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