public ReturnDataToKendo ReturnTradeViewDataAll(string userName, TdmsDbContext context)
{
const string source = "TradeBrowser";
const string storedProcedureName = "usp_returnTradeList_Query";
var returnQuickFind = new ReturnQuickFindSort(context);
// Create required Parameter for a query
var parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("user_name", userName);
var tempSortQ = returnQuickFind.ReturnQuickSort(userName, source);
if (!string.IsNullOrWhiteSpace(tempSortQ.Trim()))
{
tempSortQ = string.Format(" Order By {0}", tempSortQ.Trim());
}
var queryStringParameter = string.Format(" {0} {1}", returnQuickFind.ReturnQueryString(userName, source),
tempSortQ);
parameters[1] = new SqlParameter("QueryString", queryStringParameter);
var returnData = new ReturnDataToKendo(context);
// Return query parameter together with Kendo Grid default parameters
// Sorting and Filtering to be added
return(returnData.ReturnKendoDataAll <TradeListModel>(userName, source, parameters, storedProcedureName));
}
private static void RemoveFindSortState(string userName, TdmsDbContext context)
{
var removeStateFindSort = new ReturnQuickFindSort(context);
removeStateFindSort.RemoveLastUsedTodaySortingForUsername(userName);
removeStateFindSort.RemoveLastUsedTodayFindUserName(userName);
}
public void UpdateGridster(List <tdGridsterModel> list, string userName, TdmsDbContext context)
{
_context = context;
_context.Gridster.RemoveRange(_context.Gridster);
foreach (var gridModel in list)
{
gridModel.user_name = userName;
gridModel.id = Guid.NewGuid().ToString();
_context.Gridster.Add(gridModel);
}
}
/// <summary>
/// Checks if user with given password exists in the database
/// </summary>
/// <param name="username">User name</param>
/// <param name="password">User password</param>
/// <returns>True if user exist and password is correct</returns>
public bool IsValid(string username, string password, TdmsDbContext _context)
{
var userLogin = _context.Set <usp_returnUserbyUserName_Result>().FromSql("EXEC usp_returnUserbyUserName @p0", username).FirstOrDefault(a => a.psw == GetSwcMd5(password) && a.user_status == 0);
if (userLogin != null)
{
LogLoginAttempt(username, true, _context);
return(true);
}
LogLoginAttempt(username, false, _context);
return(false);
}
public List <tdGridsterModel> GetGridster(string userName, TdmsDbContext context)
{
_context = context;
var newGridster = new List <tdGridsterModel>();
var query = _context.Gridster.ToList <tdGridsterModel>().Where(c => c.user_name == userName);
foreach (var value in query)
{
var retriedGridItem = value;
_context.Gridster.Update(retriedGridItem);
newGridster.Add(retriedGridItem);
}
return(newGridster);
}
public TDMSFailedTradesController(TdmsDbContext context)
{
_context = context;
}
public TdmsManualMatchController(TdmsDbContext context)
{
_context = context;
}
public ReturnQuickFindSort(TdmsDbContext context)
{
_context = context;
}
public HomeController(IServiceProvider services)
{
UserManager = services.GetRequiredService <UserManager <ApplicationUser> >();
_context = services.GetService <TdmsDbContext>();
}
private static void LogLoginAttempt(string userId, bool loginSuccess, TdmsDbContext context)
{
context.Database.ExecuteSqlCommand("EXEC usp_LogLoginAttempt @p0, @p1 ", userId, loginSuccess);
}
public SecurityRepository(TdmsDbContext context)
{
_context = context;
}
public TDMSTradeSearchController(TdmsDbContext context)
{
_context = context;
}
public ReturnDataToKendo(TdmsDbContext context)
{
_context = context;
}
public IEnumerable<QuickSort> GetQuickSortName(string userName, string source, TdmsDbContext context)
{
var newItem = new ReturnQuickFindSort(context);
return newItem.ReturnQuickSort(userName, source, true);
}
public MenuController(IServiceProvider services)
{
_context = services.GetService <TdmsDbContext>();
}
public ExportController(TdmsDbContext context)
{
_context = context;
}
public ManualMatchRepository(TdmsDbContext context)
{
_context = context;
}
public FileRepository(TdmsDbContext context)
{
_context = context;
}
public QuickSortController(TdmsDbContext context)
{
_context = context;
}
public AttachFileController(TdmsDbContext context)
{
_context = context;
}
public QuickFindSortRepository(TdmsDbContext context)
{
_context = context;
}
public TradePrintOptionsController(TdmsDbContext context)
{
_context = context;
}
public BulkEditController(TdmsDbContext context)
{
_context = context;
}
public LocationRepository(TdmsDbContext context)
{
_context = context;
}
public LocationController(TdmsDbContext context)
{
_context = context;
}
public TradeDetailController(TdmsDbContext context)
{
_context = context;
}
