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 stockSettingsViewModel GetStockSettings(string userGUID)
{
try
{ if (!string.IsNullOrEmpty(userGUID))
{
var ctx = new data.co_stocksEntities();
var item = ctx.stock_settings.Where(x => x.user_guid == userGUID).FirstOrDefault();
int minute = (item != null) ? item.stock_ticker_min : CommonKeys.DEFAULT_STOCK_TICKER_MINUTE;
return(new stockSettingsViewModel()
{
ticker_minute = minute, user_guid = userGUID
});
}
return(new stockSettingsViewModel()
{
ticker_minute = CommonKeys.DEFAULT_STOCK_TICKER_MINUTE
}); }
catch (Exception ex)
{
throw ex;
}
}
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);
}
