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