public void AddAcc(CheckUser user)
{
var connection = new SqlConnection(connectionString);
try
{
connection.Open();
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = InsertAcc;
command.Parameters.Add(new SqlParameter("@Phone", user.Phone));
command.Parameters.Add(new SqlParameter("@Pass", user.Pwd));
command.Parameters.Add(new SqlParameter("@UserName", user.UserName));
command.Parameters.Add(new SqlParameter("@Status", user.Status));
command.Parameters.Add(new SqlParameter("@Role_Id", user.Role));
command.Parameters.Add(new SqlParameter("@Create_At", user.Create_At));
int ID = command.ExecuteNonQuery();
connection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
/// <summary>
/// 账号输入 TextBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void userName_TextChanged(object sender, TextChangedEventArgs e)
{
string userNameTmp = userName.Text.ToString();
string userPsdTem = userPassword.Password.ToString();
decimal moneySum;
decimal.TryParse(rechargeSum.Text.ToString(), out moneySum);
imgIsSuccess.Visibility = System.Windows.Visibility.Hidden;
userPassword.BorderBrush = scNormal;
if (userPsdTem != null && userNameTmp != null)
{
if (CheckUser.checkUserIsLegal(userNameTmp))
{
//正确
userName.BorderBrush = scRight;
isUserName = true;
recharge.Background = scEnable;
balance.Content = CheckUser.getBalance(userNameTmp);
}
else
{
//错误
recharge.Background = scUnEnable;
userName.BorderBrush = scError;
isUserName = false;
//余额初始化
balance.Content = "0";
}
}
}
public List <CheckUser> GetAllAcount()
{
SqlCommand com = new SqlCommand(GetAllAccount, con);
com.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable ds = new DataTable();
da.Fill(ds);
List <CheckUser> data = new List <CheckUser>();
foreach (DataRow item in ds.Rows)
{
CheckUser record = new CheckUser();
record.Phone = string.IsNullOrEmpty(item["PhoneUser"].ToString()) ? null : item["PhoneUser"].ToString();
record.Role = string.IsNullOrEmpty(item["Name"].ToString()) ? null : item["Name"].ToString();
record.UserName = string.IsNullOrEmpty(item["UserName"].ToString()) ? null : item["UserName"].ToString();
record.Pwd = string.IsNullOrEmpty(item["Password"].ToString()) ? null : item["Password"].ToString();
record.ID_User = item["ID"].ToString() == null ? 0 : Int32.Parse(item["ID"].ToString());
record.Status = string.IsNullOrEmpty(item["Status"].ToString()) ? null : item["Status"].ToString();
data.Add(record);
}
return(data);
}
public async Task <ActionResult> getuser()
{
string input = null;
using (StreamReader reader = new StreamReader(Request.Body, Encoding.UTF8))
{
input = await reader.ReadToEndAsync();
}
b2cUserModel inputClaims = b2cUserModel.Parse(input);
string apiKey = "your-apikey";
string apiSecret = "your-apisecret";
string id = inputClaims.objectid;
string base_url = string.Format("https://api.typingdna.com/user/{0}", id);
var response = await getUser(apiKey, apiSecret, base_url);
CheckUser checkUserResponse = CheckUser.FromJson(response);
outputModel output = new outputModel(string.Empty, HttpStatusCode.OK)
{
success = checkUserResponse.Success,
count = checkUserResponse.Count
};
return(Ok(output));
}
public ActionResult ChangePassword(ChangePasswordViewModel changePassword)
{
if (ModelState.IsValid)
{
//برای استفاده از یوزر کاربر رد بازیابی اطلاعات آن
int UserID = CheckUser.GetUserID();
//int Email = CheckUser.GetUserEmail();
var user = db.UserLogin.Find(UserID);
string OldPass = FormsAuthentication.HashPasswordForStoringInConfigFile(changePassword.OldPassword,
"MD5");
if (user.Password == OldPass)
{
user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(changePassword.Password,
"MD5");
db.SaveChanges();
ViewBag.IsOk = true;
}
else
{
ModelState.AddModelError("OldPassword", "کلمه عبور فعلی صحیح نمی باشد");
}
}
return(View(changePassword));
}
/// <summary>
/// 检查用户调用时是否在CD中
/// 对任何可能刷屏的指令都有效
/// </summary>
/// <param name="groupId">群号</param>
/// <param name="userId">用户ID</param>
/// <returns>是否在CD中</returns>
public static bool isInCD(long groupId, long userId)
{
#if DEBUG
return(false);
#else
DateTime time = DateTime.Now; //获取当前时间
CheckUser user = new CheckUser
{
GroupId = groupId,
UserId = userId
};
//尝试从字典中取出上一次调用的时间
if (LastChatDate.TryGetValue(user, out DateTime last_use_time) &&
(long)(time - last_use_time).TotalSeconds < 60)
{
//刷新调用时间
LastChatDate[user] = time;
return(true);
}
else
{
//刷新/写入调用时间
LastChatDate[user] = time;
return(false);
}
#endif
}
public CheckUser FindAccByID(int id)
{
SqlCommand com = new SqlCommand(GetAccById, con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@ID_User", id));
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable ds = new DataTable();
da.Fill(ds);
DataRow dr = ds.NewRow();
if (ds.Rows.Count > 0)
{
dr = ds.Rows[0];
}
CheckUser record = new CheckUser();
record.Phone = string.IsNullOrEmpty(dr["PhoneUser"].ToString()) ? null : dr["PhoneUser"].ToString();
record.Role = string.IsNullOrEmpty(dr["Name"].ToString()) ? null : dr["Name"].ToString();
record.UserName = string.IsNullOrEmpty(dr["UserName"].ToString()) ? null : dr["UserName"].ToString();
record.Pwd = string.IsNullOrEmpty(dr["Password"].ToString()) ? null : dr["Password"].ToString();
record.ID_User = dr["ID"].ToString() == null ? 0 : Int32.Parse(dr["ID"].ToString());
record.Status = string.IsNullOrEmpty(dr["Status"].ToString()) ? null : dr["Status"].ToString();
return(record);
}
internal void SendObject(CheckUser cu)
{
try
{
if (myMark == "Server")
{
for (int i = 0; i < n; i++)
{
socketStream = new NetworkStream(players[i].connection);
writer = new BinaryWriter(socketStream);
reader = new BinaryReader(socketStream);
writer.Write(Check_Head + getByteArrayWithObject(cu).Length.ToString());
writer.Write(getByteArrayWithObject(cu));
}
}
else
{
writer.Write(Check_Head + getByteArrayWithObject(cu).Length.ToString());
writer.Write(getByteArrayWithObject(cu));
}
}
catch (SocketException)
{
MessageBox.Show("±µ¤f³]©w¿ù»~¡I");
}
}
/// <summary>
/// 用户名输入框
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
isSkip = false;
//警告信息隐藏
spWarning.Visibility = System.Windows.Visibility.Hidden;
isOut = false;
//隐藏图标，当前站点，票的状态
imgIsSuccess.Visibility = System.Windows.Visibility.Hidden;
spCurrentStation.Visibility = System.Windows.Visibility.Hidden;
dgUser.Visibility = System.Windows.Visibility.Hidden;
//用户名是否正确
isUser = false;
//检查用户名
if (CheckUser.checkUserIsLegal(tbUserName.Text))
{
//用户名正确
isUser = true;
//显示票状态
if (tictetsState(tbUserName.Text))
{
}
else
{
//未知的错误
}
}
}
private void btnLogin_Click(object sender, EventArgs e) {
if (tbUsername.Text == "" && tbPassword.Text == "") {
MessageBox.Show("Fill in all the fields");
tbUsername.Focus();
} else if (tbUsername.Text == "") {
MessageBox.Show("Give a username");
tbUsername.Focus();
} else if (tbPassword.Text == "") {
MessageBox.Show("Give a password");
tbPassword.Focus();
} else if (tbUsername.Text.Length > 0 && tbPassword.Text.Length > 0) {
CheckUser checkUsername = new CheckUser();
checkUser = checkUsername.checkUserOnLogin(tbUsername.Text, tbPassword.Text);
if (checkUser) {
CheckUser checkUser = new CheckUser();
int id = checkUser.returnUserId(tbUsername.Text);
string username = checkUser.returnUsername(tbUsername.Text);
int roleId = checkUser.returnRoleId(tbUsername.Text);
MessageBox.Show("You are succesfully logged in!");
MainForm mainForm = new MainForm(id, username, roleId);
mainForm.Show();
Hide();
}
else {
MessageBox.Show("Wrong username or password");
}
}
}
//[CheckLogin]
public ActionResult HistoryDeal(DateTime?startDate, DateTime?expirationDate, int?typePay, int?status)
{
if ((CheckUser)Session["Account"] != null)
{
CheckUser current = (CheckUser)Session["Account"];
if (startDate != null || expirationDate != null || typePay != null || status != null)
{
SearchHistory search = new SearchHistory
{
ID_Acc = current.ID_User, StartDate = startDate, ExpirationDate = expirationDate, TypePay = typePay, Status = status
};
List <Order> data = db.SearchHistory(search);
ViewBag.startDate = startDate;
ViewBag.expirationDate = expirationDate;
ViewBag.typePay = typePay;
ViewBag.orders = data;
ViewBag.count = data.Count;
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
var orders = db.GetOrderByIDAcc(current.ID_User);
ViewBag.orders = orders;
ViewBag.count = orders.Count;
return(View());
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult AccountUser(FormCollection fc)
{
if ((CheckUser)Session["Account"] != null)
{
CheckUser currentUser = (CheckUser)Session["Account"];
var record = new Users();
record.ID = currentUser.ID_User;
record.FullName = fc["fullname"].Trim();
record.Address = fc["address"].Trim();
record.Birthday = fc["birthday"].Trim();
record.Gender = fc["gender"].Trim().Equals("Nam") ? 1 : 2;
record.Identity_people = Int32.Parse(fc["cmnd"].Trim());
if (ModelState.IsValid)
{
db.UpdateInformationUser(record);
return(RedirectToAction("AccountUser"));
}
return(View(record));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
/// <summary>
/// 检查用户调用时是否在CD中
/// 对任何可能刷屏的指令都有效
/// </summary>
/// <param name="checkDict">调用记录字典</param>
/// <param name="groupId">群号</param>
/// <param name="userId">用户ID</param>
/// <returns>是否在CD中</returns>
public static bool IsInCD(this Dictionary <CheckUser, DateTime> checkDict, long groupId, long userId)
{
#if DEBUG
return(false);
#else
var time = DateTime.Now; //获取当前时间
var user = new CheckUser
{
GroupId = groupId,
UserId = userId
};
//尝试从字典中取出上一次调用的时间
if (checkDict.TryGetValue(user, out DateTime last_use_time) &&
(long)(time - last_use_time).TotalSeconds < 60)
{
//刷新调用时间
checkDict[user] = time;
return(true);
}
//刷新/写入调用时间
checkDict[user] = time;
return(false);
#endif
}
public async Task <IActionResult> Create([Bind("CheckUserId,CheckUserName")] CheckUser checkUser)
{
/*Check Session */
var page = "37";
var typeofuser = "";
var PermisionAction = "";
// CheckSession
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Username")))
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
else
{
typeofuser = HttpContext.Session.GetString("TypeOfUserId");
PermisionAction = HttpContext.Session.GetString("PermisionAction");
if (PermisionHelper.CheckPermision(typeofuser, PermisionAction, page) == false)
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
}
/*Check Session */
if (ModelState.IsValid)
{
_context.Add(checkUser);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(checkUser));
}
public IActionResult Register(RegisterViewModel register)
{
if (!ModelState.IsValid)
{
return(View(register));
}
CheckUser checkUserName = _userService.CheckUserName(register.UserName);
CheckUser checkEmail = _userService.CheckEmail(register.Email);
if (checkUserName != CheckUser.OK || checkEmail != CheckUser.OK)
{
ViewBag.Check = checkUserName;
return(View(register));
}
User user = new User()
{
Email = register.Email.Trim().ToLower(),
PhoneNumber = register.PhoneNumber.Trim(),
UserName = register.UserName.ToLower(),
Password = PasswordHelper.EncodePasswordMd5(register.Password)
};
_userService.RegisterUser(user);
return(View("SuccessRegister", register));
}
public IActionResult Register(RegisterViewModels register)
{
if (!ModelState.IsValid)
{
return(View(register));
}
CheckUser checkUser = userService.CheckUser(register.UserName, register.Email);
if (checkUser != CheckUser.Ok)
{
ViewBag.Check = checkUser;
return(View(register));
}
User user = new User
{
Email = register.Email.Trim(),
Password = PasswordHelper.EncodePasswordMd5(register.Password.Trim()),
UserName = register.UserName.Trim()
};
userService.RegisterUser(user);
return(View("SuccessRegister", register));
}
private void userName_TextChanged(object sender, TextChangedEventArgs e)
{
imgIsSuccess.Visibility = System.Windows.Visibility.Hidden;
imgIsSuccess.ToolTip = "";
string userNameTmp = userName.Text.ToString();
string userPsdTem = userPassword.Password.ToString();
userPassword.BorderBrush = scNormal;
if (userPsdTem != null && userNameTmp != null)
{
if (CheckUser.checkUserIsLegal(userNameTmp))
{
//正确
userName.BorderBrush = scRight;
delete.Background = scEnable;
balance.Content = CheckUser.getBalance(userNameTmp);
isUserName = true;
}
else
{
//错误
delete.Background = scUnEnable;
userName.BorderBrush = scError;
//余额初始化
balance.Content = "0";
isUserName = false;
}
}
}
public ReduxControl()
{
string baseDir = AppDomain.CurrentDomain.BaseDirectory;
Settings = new ReduxSettings(Path.Combine(baseDir, "ReduxSettings.json"));
// Соединение с базой
try
{
Settings.DB.Connect();
}
catch (Exception ex)
{
Logger.WriteToTrace($"Ошибка при подключении к базе: {ex}", TraceMessageKind.Error);
}
Steam = new SteamAPI(Settings.SteamAPIKey);
Messages = new ReduxMessages(Settings.DB);
Stats = new ReduxStats(Settings.DB);
Players = new ReduxPlayers(Settings.DB);
Matches = new ReduxMatch(Settings.DB);
Builds = new ReduxBuilds(Settings.DB);
if (Settings.JWTKey.Length < 16)
{
Logger.WriteToTrace("Для корректной работы JWT ключ должен быть не менее 16 символов.", TraceMessageKind.Error);
}
// Делегат проверки пользователя и формирования требований к пользователю
CheckUser check = d => {
#if DEBUG
return(new Claim[] {
new Claim(ClaimTypes.Name, "Develop"),
new Claim(ClaimTypes.Role, "Admin")
});
#endif
dynamic row = Settings.DB.Query(
"select *" +
" from redux_users" +
$" where Username = '******'").FirstOrDefault();
if (row == null)
{
return(null);
}
if (row.password.ToString() != d["password"])
{
return(null);
}
return(new Claim[] {
new Claim(ClaimTypes.Name, row.username.ToString()),
new Claim(ClaimTypes.Role, row.role.ToString())
});
};
JWT = new JwtControl(check, Settings.JWTKey);
}
public byte[] getByteArrayWithObject(CheckUser check)
{
MemoryStream ms = new MemoryStream();
BinaryFormatter bf1 = new BinaryFormatter();
bf1.Serialize(ms, check);
return(ms.ToArray());
}
public void Enabled_Button(CheckUser check)
{
this.Chow.Enabled = check.Chow;
this.Pong.Enabled = check.Pong;
this.Kong.Enabled = check.Kong;
this.Win.Enabled = check.Win;
this.DarkKong.Enabled = check.DarkKong;
this.Pass.Enabled = check.Pass;
}
public JwtControl(CheckUser checkUserDelegate, string secretKey)
{
checkUser = checkUserDelegate;
// Секретный ключ шифрования
key = string.IsNullOrEmpty(secretKey) || secretKey.Length < 16
? null
: new SymmetricSecurityKey(Encoding.UTF8.GetBytes(secretKey));
}
/// <summary>
/// 充值按钮点击
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void recharge_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
imgIsSuccess.Focus();
//用户名是否正确
if (isUserName)
{
//充值是否成功图片可见
imgIsSuccess.Visibility = System.Windows.Visibility.Visible;
string userNameTmp = userName.Text.ToString();
string userPsdTem = userPassword.Password.ToString();
decimal moneySum;
decimal.TryParse(rechargeSum.Text.ToString(), out moneySum);
//密码是否为空
if (isUserName && userNameTmp != null)
{
//密码是否正确
if (CheckUser.checkUserIsLegal(userNameTmp, userPsdTem))
{
if (!rechargeSum.Text.ToString().Equals("") && Regex.IsMatch(rechargeSum.Text.ToString(), @"^[0-9]*$"))
{
if (CheckUser.rechargeToCo(moneySum))
{
CheckUser.rechargeMoney(userNameTmp, moneySum);
balance.Content = CheckUser.getBalance(userNameTmp);
userPassword.BorderBrush = scRight;
rechargeSum.BorderBrush = scRight;
//显示充值成功图片
imgIsSuccess.Source = new BitmapImage(new Uri("/images/成功.png", UriKind.Relative));
imgIsSuccess.ToolTip = "充值成功";
}
}
else
{
rechargeSum.BorderBrush = scError;
imgIsSuccess.Source = new BitmapImage(new Uri("/images/失败.png", UriKind.Relative));
imgIsSuccess.ToolTip = "金额输入错误";
}
}
else
{
userPassword.BorderBrush = scError;
imgIsSuccess.Source = new BitmapImage(new Uri("/images/失败.png", UriKind.Relative));
imgIsSuccess.ToolTip = "密码错误";
}
}
else
{
userPassword.BorderBrush = scError;
imgIsSuccess.Source = new BitmapImage(new Uri("/images/失败.png", UriKind.Relative));
imgIsSuccess.ToolTip = "密码错误";
}
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
//kiem tra dang nhap
CheckUser user = (CheckUser)HttpContext.Current.Session["Account"];
if (user == null || user.Role.Equals("User"))
{
// chay vao day mà k chuyển trang nữa nhỉ còn sang cổnller
HttpContext.Current.Response.Redirect("/Home/Index");
base.OnActionExecuting(filterContext);
}
}
public IHttpActionResult post(CheckUser value)
{
List <administrative> adminitrativeList = new List <administrative>();
List <admin> adminList = new List <admin>();
List <student> studentList = new List <student>();
List <teacher> teacherList = new List <teacher>();
using (universityEntities db = new universityEntities())
{
adminitrativeList = (from a in db.administratives
where a.username == value.username && a.password == value.password
select a).ToList();
adminList = (from a in db.admins
where a.username == value.username && a.password == value.password
select a).ToList();
studentList = (from s in db.students
where s.username == value.username && s.password == value.password
select s).ToList();
teacherList = (from t in db.teachers
where t.username == value.username && t.password == value.password
select t).ToList();
if (adminitrativeList.Count == 1 && adminList.Count == 0 && studentList.Count == 0 && teacherList.Count == 0)
{
var result = new { Success = true, Role = "Administrative", Message = adminitrativeList[0] };
return(Json(result));
}
else if (adminitrativeList.Count == 0 && adminList.Count == 1 && studentList.Count == 0 && teacherList.Count == 0)
{
var result = new { Success = true, Role = "Admin", Message = adminList[0] };
return(Json(result));
}
else if (adminitrativeList.Count == 0 && adminList.Count == 0 && studentList.Count == 1 && teacherList.Count == 0)
{
var result = new { Success = true, Role = "Student", Message = studentList[0] };
return(Json(result));
}
else if (adminitrativeList.Count == 0 && adminList.Count == 0 && studentList.Count == 0 && teacherList.Count == 1)
{
var result = new { Success = true, Role = "Teacher", Message = teacherList[0] };
return(Json(result));
}
else
{
var result = new { Success = false, Error = "Authentication failed, incorrect username or password." };
return(Json(result));
}
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
DBA.CheckUser chk = new CheckUser();
if (chk.loggedIn(txtUsername.Text.Trim(), txtPassword.Text.Trim()))
{
VisibleControls();
}
else
{
HideControls();
}
}
public IHttpActionResult GetUser([FromBody] CheckUser account)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (_db.Users.FirstOrDefault(user => user.Account == account.Account) == null)
{
return(Ok("此帳號可以使用"));
}
return(BadRequest("帳號已存在"));
}
public ActionResult Remark(CheckUser CheckUser)
{
var baseCheckUser = this.Entity.CheckUser.Where(o => o.Id == CheckUser.Id).FirstOrDefault();
if (baseCheckUser == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
baseCheckUser.Remark = CheckUser.Remark;
this.Entity.SaveChanges();
BaseRedirect();
return(null);
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
isIn = false;
imgIsSuccess.Visibility = System.Windows.Visibility.Hidden;
dgUser.Visibility = System.Windows.Visibility.Hidden;
isUser = false;
if (CheckUser.checkUserIsLegal(tbUserName.Text))
{
isUser = true;
if (tictetsState(tbUserName.Text))
{
}
}
}
public async Task <IActionResult> Edit([Bind("CheckUserId,CheckUserName")] CheckUser checkUser)
{
/*Check Session */
var page = "38";
var typeofuser = "";
var PermisionAction = "";
// CheckSession
if (string.IsNullOrEmpty(HttpContext.Session.GetString("Username")))
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
else
{
typeofuser = HttpContext.Session.GetString("TypeOfUserId");
PermisionAction = HttpContext.Session.GetString("PermisionAction");
if (PermisionHelper.CheckPermision(typeofuser, PermisionAction, page) == false)
{
Alert("คุณไม่มีสิทธิ์ใช้งานหน้าดังกล่าว", NotificationType.error);
return(RedirectToAction("Index", "Home"));
}
}
/*Check Session */
if (ModelState.IsValid)
{
try
{
_context.Update(checkUser);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CheckUserExists(checkUser.CheckUserId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult AccountUser()
{
if ((CheckUser)Session["Account"] != null)
{
CheckUser current = (CheckUser)Session["Account"];
Users us = db.FindAccByID2(current.ID_User);
return(View(us));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Update2(CheckUser user)
{
if (user.ID_User is null)
{
user.Create_At = DateTime.Now;
db.AddAcc(user);
}
else
{
db.UpdateUser(user);
}
int x = 1;
return(RedirectToAction("Index"));
}
