public IEnumerable <usp_returnTDMSMenu_Result> GetMenu(string userName)
{
var parameters = new[]
{
new SqlParameter("@user_name", userName)
};
var repo = new GenericRepository <usp_returnTDMSMenu_Result>(_context);
return(repo.ExecuteStoredProcedure("usp_returnTDMSMenu", parameters));
}
public IQueryable GetAutoComplete(string columnName, string source, string userName)
{
var parameters = new[]
{
new SqlParameter("@user_name", userName)
};
var columnList = "new (" + columnName + ")";
var repo = new GenericRepository <TradeListModel>(_context);
return(repo.ExecuteStoredProcedure("usp_returnTradeList_Query", parameters).Select(columnList).FirstOrDefault());
}
public IEnumerable <usp_ReturnBrokerPerformance_Result> BrokerPerformance(string time, string userName)
{
var intTimePeriod = 0;
int.TryParse(time, out intTimePeriod);
var parameters = new[]
{
new SqlParameter("@user_name", userName),
new SqlParameter("@TimePeriod", intTimePeriod)
};
var repo = new GenericRepository <usp_ReturnBrokerPerformance_Result>(_context);
return(repo.ExecuteStoredProcedure("usp_ReturnBrokerPerformance", parameters));
}
public IEnumerable <QuickfindMC> ReturnQuickFind(string source, bool system, string userName)
{
IEnumerable <QuickfindMC> linqQuery = null;
var parameters = new object[]
{
new SqlParameter("@user_name", userName),
new SqlParameter("@SourceName", source),
new SqlParameter("@System", system)
};
var repo = new GenericRepository <QuickfindMC>(_context);
linqQuery = repo.ExecuteStoredProcedure("usp_returnquickfind", parameters);
return(linqQuery);
}
public IEnumerable <QuickfindMC> SaveQuickFind(string userName, string source, string description, bool lastUsed, bool lastUsedToday)
{
IEnumerable <QuickfindMC> linqQuery = null;
var parameters = new object[]
{
new SqlParameter("@user_name", userName),
new SqlParameter("@SourceName",
source),
new SqlParameter("@Description",
description),
new SqlParameter("@LastUsed",
lastUsed),
new SqlParameter("@LastUsedToday",
lastUsedToday)
};
var repo = new GenericRepository <QuickfindMC>(_context);
linqQuery = repo.ExecuteStoredProcedure("usp_SaveQuickFind", parameters);
return(linqQuery);
}
public IEnumerable ReturnPortfolioContact()
{
var repo = new GenericRepository <usp_ReturnFailCodes_Result>(_context);
return(repo.ExecuteStoredProcedure("usp_ReturnContactTypeList"));
}
public IEnumerable ReturnComment()
{
var repo = new GenericRepository <usp_ReturnFailCodes_Result>(_context);
return(repo.ExecuteStoredProcedure("usp_ReturnProblemCodes"));
}
public IList <usp_ReturnFailCodes_Result> ReturnFailCodesList()
{
var repo = new GenericRepository <usp_ReturnFailCodes_Result>(_context);
return(repo.ExecuteStoredProcedure("usp_ReturnFailCodesList").ToList());
}
