public UserCreateResult User_create(string loginName, string passwd, string name, int type, decimal cnyFree)
{
using (var gpEntities = new GPEntities())
{
return(gpEntities.user_create(loginName, Crypto.HashPassword(passwd), name, type, cnyFree).First() == 0 ? UserCreateResult.Ok : UserCreateResult.Repeat);
}
}
public CancelOrderResult Cancel_Order(long userId, long orderId)
{
using (var gpEntities = new GPEntities())
{
return(gpEntities.cancel_order(userId, orderId).First() == 0 ? CancelOrderResult.Ok : CancelOrderResult.Wrong);
}
}
private static string GetHashedPassword(long userId)
{
using (var gpEntities = new GPEntities())
{
return(gpEntities.users.FirstOrDefault(u => u.user_id == userId)?.passwd);
}
}
private static long?GetUserId(string loginName)
{
using (var gpEntities = new GPEntities())
{
var q = gpEntities.users.FirstOrDefault(u => u.login_name == loginName);
return(q?.user_id);
}
}
public static bool IsEmailExists(string email)
{
using (GPEntities db = new GPEntities())
{
var exist = db.Patients.Where(p => p.Email == email).FirstOrDefault();
return(exist != null);
}
}
public List <StockResult> GetAllStocks()
{
using (var gpEntities = new GPEntities())
{
return(gpEntities.stocks.Select(x => new StockResult {
StockId = x.stock_id, Name = x.name, Price = x.price
}).ToList());
}
}
public List <TransactionResult> GetRecentTrans(int stockId, int num)
{
using (var gpEntities = new GPEntities())
{
return(gpEntities.transactions.Where(x => x.stock_id == stockId).OrderBy(x => x.create_datetime).Take(num).Select(x => new TransactionResult()
{
CreateDateTime = x.create_datetime, Dealed = x.dealed, Price = x.deal_price, TranId = x.trans_id, TranType = x.type
}).ToList());
}
}
public List <StockDepthResult> Stock_depth(int stockId, int type)
{
using (var gpEntities = new GPEntities())
{
var res = gpEntities.stock_depth(stockId, type).ToList();
return(res.Select(x => new StockDepthResult()
{
Price = x.price,
Num = x.num ?? 0
}).ToList());
}
}
public List <UserStockResult> User_stock(long userId)
{
using (var gpEntities = new GPEntities())
{
var res = gpEntities.user_stock(userId).ToList();
return(res.Select(x => new UserStockResult()
{
StockId = x.stock_id,
NumFree = x.num_free,
NumFreezed = x.num_freezed
}).ToList());
}
}
public UserCnyResult User_cny(long userId)
{
using (var gpEntities = new GPEntities())
{
decimal?cnyFree = 0;
decimal?cnyFreezed = 0;
decimal?gpMoney = 0;
var cf = new ObjectParameter("cny_free", cnyFree);
var cfed = new ObjectParameter("cny_freezed", cnyFreezed);
var gm = new ObjectParameter("gp_money", gpMoney);
gpEntities.user_cny(userId, cf, cfed, gm);
return(new UserCnyResult(cf.Value as decimal? ?? 0, cfed.Value as decimal? ?? 0, gm.Value as decimal? ?? 0));
}
}
private static void GetUserInfo(long userId, out string name, out int?type)
{
using (var gpEntities = new GPEntities())
{
var q = gpEntities.users.FirstOrDefault(u => u.user_id == userId);
if (q != null)
{
name = q.name;
type = q.type;
}
else
{
name = null;
type = null;
}
}
}
public ExecOrderResult Exec_Order(long userId, int stockId, int type, decimal price, int amount)
{
using (var gpEntities = new GPEntities())
{
switch (gpEntities.exec_order(userId, stockId, type, price, amount).First())
{
case 0: return(ExecOrderResult.Ok);
case -1: return(ExecOrderResult.NotEnoughCnyFree);
case -2: return(ExecOrderResult.NotEnoughNumFree);
case -3: return(ExecOrderResult.Wrong);
default: return(ExecOrderResult.Wrong);
}
}
}
public StockResult GetStock(int stockId, DateTime dateTime)
{
using (var gpEntities = new GPEntities())
{
var s = gpEntities.stocks.FirstOrDefault(x => x.stock_id == stockId);
Debug.Assert(s != null, nameof(s) + " != null");
var q = gpEntities.transactions.Where(x => x.stock_id == stockId && dateTime > x.create_datetime)
.OrderBy(x => x.create_datetime).ToList();
var qday = q.Where(x => dateTime - x.create_datetime >= TimeSpan.FromDays(1)).ToList();
var qremain = q.Except(qday);
var qf = qday.LastOrDefault() ?? qremain.FirstOrDefault();
return(qf != null ? new StockResult {
StockId = stockId, Name = s.name, Price = qf.deal_price
} : new StockResult {
StockId = stockId, Name = s.name, Price = s.price
});
}
}
public List <UserOrderResult> User_order(long userId)
{
using (var gpEntities = new GPEntities())
{
var res = gpEntities.user_order(userId).ToList();
return(res.Select(x => new UserOrderResult
{
OrderId = x.order_id,
CreateDatetime = x.create_datetime,
UserId = x.user_id,
StockId = x.stock_id,
Type = x.type,
Price = x.price,
Undealed = x.undealed,
Dealed = x.dealed,
Canceled = x.canceled
}).ToList());
}
}
public UserRepasswdResult User_repasswd(long userId, string oldPasswd, string newPasswd)
{
using (var gpEntities = new GPEntities())
{
var hashedPassword = GetHashedPassword(userId);
if (hashedPassword == null)
{
return(UserRepasswdResult.Wrong);
}
if (!Crypto.VerifyHashedPassword(hashedPassword, oldPasswd))
{
return(UserRepasswdResult.Wrong);
}
var hashedNewPasswd = Crypto.HashPassword(newPasswd);
var q = gpEntities.users.FirstOrDefault(u => u.user_id == userId);
if (q == null)
{
return(UserRepasswdResult.Wrong);
}
q.passwd = hashedNewPasswd;
gpEntities.SaveChanges();
return(UserRepasswdResult.Ok);
}
}
