public Result Login(loginViewModel model) { var result = new Result() { IsSuccess = true }; try { var ctx = new data.co_stocksEntities(); string userName = model.username; string password = model.password; var users = ctx.s_users.Where(x => x.username == userName && x.password == password).ToList(); if (!users.Any()) { result.ReturnMessage = "User can not found"; result.IsSuccess = false; return(result); } var user = users.FirstOrDefault(); user.last_logindate = DateTime.Now; ctx.SaveChanges(); result.ReturnMessageList = new List <string>(); result.ReturnMessageList.Add(user.user_guid); result.ReturnMessageList.Add(user.username); } catch (Exception ex) { result.ReturnMessage = ex.Message; result.IsSuccess = false; } return(result); }
public bool UpdateStockTickers(int tickerMinute, string userGUID) { try { if (!string.IsNullOrEmpty(userGUID)) { var ctx = new data.co_stocksEntities(); var stock_ticker = ctx.stock_settings.Where(x => x.user_guid == userGUID).FirstOrDefault(); if (stock_ticker != null) { stock_ticker.stock_ticker_min = tickerMinute; } else { ctx.stock_settings.Add(new data.stock_settings() { stock_ticker_min = tickerMinute, user_guid = userGUID }); } ctx.SaveChanges(); return(true); } return(false); } catch (Exception ex) { throw ex; } }
public Result Register(registerViewModel model) { var result = new Result() { IsSuccess = true }; try { if (!model.password.Equals(model.passwordRepeat)) { result.ReturnMessage = "Password and password repeat did not match"; result.IsSuccess = false; return(result); } var ctx = new data.co_stocksEntities(); string userName = model.username; var users = ctx.s_users.Where(x => x.username == userName).ToList(); if (!users.Any()) { string guid = Guid.NewGuid().ToString().Replace("-", ""); ctx.s_users.Add(new data.s_users() { username = model.username, password = model.password, name = model.name, surname = model.surname, user_guid = guid, creation_date = DateTime.Now }); ctx.SaveChanges(); result.ReturnMessageList = new List <string>(); result.ReturnMessageList.Add(guid); result.ReturnMessageList.Add(model.username); } else { result.ReturnMessage = "This username is exists"; result.IsSuccess = false; } } catch (Exception ex) { result.ReturnMessage = ex.Message; result.IsSuccess = false; } return(result); }
public bool DeleteStock(int stockId, string userGUID) { try { if (!string.IsNullOrEmpty(userGUID)) { var ctx = new data.co_stocksEntities(); var stock = ctx.s_stocks.Where(x => x.Id == stockId && x.user_guid == userGUID).FirstOrDefault(); if (stock != null) { ctx.s_stocks.Remove(stock); ctx.SaveChanges(); return(true); } } } catch (Exception ex) { throw ex; } return(false); }
public Result AddStock(stockViewModel model) { var result = new Result() { IsSuccess = false }; try { if (!string.IsNullOrEmpty(model.user_guid)) { var ctx = new data.co_stocksEntities(); string code = model.code; var stocks = ctx.s_stocks.Where(x => x.code == code).ToList(); if (stocks.Any()) { result.ReturnMessage = "this code is exists"; return(result); } ctx.s_stocks.Add(new data.s_stocks() { code = model.code, name = model.name, quantity = model.quantity, is_active = true, user_guid = model.user_guid }); ctx.SaveChanges(); result.IsSuccess = true; result.ReturnMessage = "Stock added"; } } catch (Exception ex) { result.ReturnMessage = ex.Message; result.IsSuccess = false; } return(result); }