public ActionResult RechargeMoney(RechargeMoney model) { if (!ModelState.IsValid) { return View(); } string updateBy = AccountInfo.GetUserName(Request); string username = model.Username; int amountOfMoney = 0; if (!string.IsNullOrEmpty(model.AmountOfMoney.ToString())) { amountOfMoney = model.AmountOfMoney; } string transactionContent = "Nạp tiền"; DateTime date = DateTime.Now; int transactionType = 2; UserInfoDetailTableAdapter userInfoAdapter = new UserInfoDetailTableAdapter(); DataTable userInfoDataTable = userInfoAdapter.GetDataByUsername(username); if (userInfoDataTable.Rows.Count != 1) { ModelState.AddModelError("", "Tên đăng nhập không tồn tại."); return View(model); } TransactionHistoryTableAdapter transactionAdapter = new TransactionHistoryTableAdapter(); try { string transactionID = transactionAdapter.RechargeMoneyScalar(username, transactionType, amountOfMoney, transactionContent, null, false, date, updateBy, date).ToString(); int id = int.Parse(transactionID); XmlSync.SaveTransactionHistoryXml(id, username, transactionType, amountOfMoney, transactionContent, null, false, date, updateBy, date, null); Session["rechargeMoney"] = "Giao dịch thành công!"; } catch (Exception ex) { Log.ErrorLog(ex.Message); Session["rechargeMoney"] = "Giao dịch thất bại!"; } return RedirectToAction("RechargeMoney", "Transaction"); }
public ActionResult EditUser(string username) { UserTypeTableAdapter userTypeAdapter = new UserTypeTableAdapter(); DataTable userTypeDT = userTypeAdapter.GetData(); List<SelectListItem> items = new List<SelectListItem>(); foreach (DataRow row in userTypeDT.Rows) { items.Add(new SelectListItem { Text = row["TypeName"].ToString(), Value = row["TypeShortName"].ToString() }); } ViewData["UserType"] = items; EditUserModel userInfo = new EditUserModel(); UserInfoDetailTableAdapter userinfoAdapter = new UserInfoDetailTableAdapter(); DataTable userinfoDataTable = userinfoAdapter.GetDataByUsername(username); try { userInfo.Username = username; userInfo.Name = userinfoDataTable.Rows[0]["Name"].ToString(); userInfo.UserTypeID = (string)userinfoDataTable.Rows[0]["TypeShortName"]; userInfo.Email = userinfoDataTable.Rows[0]["Email"].ToString(); userInfo.Role = (int)userinfoDataTable.Rows[0]["Role"]; userInfo.isActive = (bool)userinfoDataTable.Rows[0]["IsActive"]; return View(userInfo); } catch (Exception ex) { Log.ErrorLog(ex.Message); return RedirectToAction("Error", "Error"); } }
public ActionResult UserInfo() { string username = AccountInfo.GetUserName(Request); UserinfoModel userinfo = new UserinfoModel(); DataTable userInfoDataTable = new DataTable(); UserInfoDetailTableAdapter userInfoDetailAdapter = new UserInfoDetailTableAdapter(); UserInfoTableAdapter userInfoAdapter = new UserInfoTableAdapter(); userInfoDataTable = userInfoAdapter.GetDataByUsername(username); string userTypeName = null; string email = null; if (!string.IsNullOrEmpty(userInfoDataTable.Rows[0]["TypeShortName"].ToString())) { userInfoDataTable = userInfoDetailAdapter.GetDataByUsername(username); userTypeName = (string)userInfoDataTable.Rows[0]["TypeName"]; email = userInfoDataTable.Rows[0]["Email"].ToString(); } else { AccountTableAdapter accountAdapter = new AccountTableAdapter(); DataTable accountDataTable = new DataTable(); accountDataTable = accountAdapter.GetDataByUsername(username); email = accountDataTable.Rows[0]["Email"].ToString(); } DateTime date = DateTime.Parse(userInfoDataTable.Rows[0]["LastUpdatedMoney"].ToString()); int amountOfMoney = (int)userInfoDataTable.Rows[0]["AmountOfMoney"]; TransactionHistoryTableAdapter transactionAdapter = new TransactionHistoryTableAdapter(); int? money = transactionAdapter.GetCurrentMoney(username, date); if (money == null) { money = 0; } amountOfMoney += money.Value; userinfo.Username = username; userinfo.Name = userInfoDataTable.Rows[0]["Name"].ToString(); userinfo.TypeName = userTypeName; userinfo.Email = email; userinfo.AmountOfMoney = amountOfMoney; return View(userinfo); }
public ActionResult DetailUser(string username) { UserinfoModel userinfo = new UserinfoModel(); UserInfoDetailTableAdapter userinfoAdapter = new UserInfoDetailTableAdapter(); DataTable userinfoDataTable = userinfoAdapter.GetDataByUsername(username); DateTime date = DateTime.Parse(userinfoDataTable.Rows[0]["LastUpdatedMoney"].ToString()); int amountOfMoney = (int)userinfoDataTable.Rows[0]["AmountOfMoney"]; TransactionHistoryTableAdapter transactionAdapter = new TransactionHistoryTableAdapter(); int? money = transactionAdapter.GetCurrentMoney(username, date); if (money == null) { money = 0; } amountOfMoney += money.Value; userinfo.Username = username; userinfo.Name = userinfoDataTable.Rows[0]["Name"].ToString(); userinfo.TypeName = (string)userinfoDataTable.Rows[0]["TypeName"]; userinfo.Email = userinfoDataTable.Rows[0]["Email"].ToString(); userinfo.AmountOfMoney = amountOfMoney; userinfo.Role = (int)userinfoDataTable.Rows[0]["Role"]; return View(userinfo); }