public JArray GetBudget(int budgetID)
{
Dictionary <string, object> commandParams = new Dictionary <string, object>();
commandParams.Add("p_BudgetID", budgetID);
DynamicList lst = DynamicList.GetData("spCFM_BudgetLine_Details", commandParams);
return(lst.GetJson());
}
public JArray GetHomeDetails(int homeID)
{
Dictionary <string, object> commandParams = new Dictionary <string, object>();
commandParams.Add("@p_HomeID", homeID);
DynamicList lst = DynamicList.GetData("spCFM_HomeDetails_Select", commandParams);
return(lst.GetJson());
}
public JArray Get(int userID)
{
Dictionary <string, object> commandParams = new Dictionary <string, object>();
commandParams.Add("@p_ApplicationUserID", userID);
DynamicList lst = DynamicList.GetData("[dbo].[spCFM_ApplicationUser_SelectForEdit]", commandParams);
return(lst.GetJson());
}
public JArray SearchAccountStatementSummary([FromBody] AccountStatementSearch data)
{
Dictionary <string, object> commandParams = new Dictionary <string, object>();
if (data.AccountID.HasValue)
{
commandParams.Add("@p_AccountID", data.AccountID.Value);
}
if (data.AdministratorID.HasValue)
{
commandParams.Add("@p_AdministratorID", data.AdministratorID.Value);
}
commandParams.Add("@p_AccountStatementType", data.AccountStatementType);
commandParams.Add("@p_StatementmentPeriodDate", data.StatementPeriodDate);
if (data.StatementPeriodID.HasValue)
{
commandParams.Add("@p_StatementPeriodID", data.StatementPeriodID.Value);
}
if (data.ClientID.HasValue)
{
commandParams.Add("@p_ClientID", data.ClientID.Value);
}
DynamicList lst = DynamicList.GetData("[dbo].[spCCR_AccountStatementSummary_SelectForGrid]", commandParams);
if (lst.Count > 0)
{
return(lst.GetJson());
}
return(null);
}