private void button1_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(textBox_user.Text))
{
MessageBox.Show("账号不能为空！");
textBox_user.Focus();
return;
}
if (string.IsNullOrEmpty(textBox_password.Text))
{
MessageBox.Show("密码不能为空！");
textBox_password.Focus();
return;
}
CheckAccount.CheckUser(textBox_user.Text, textBox_password.Text);
MyData.SetUser(textBox_user.Text);
MyData.SetPassword(textBox_password.Text);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
textBox_password.Text = "";
textBox_password.Focus();
}
}
private CheckAccount GetUserAccount()
{
var currentUserId = User.Identity.GetUserId();
CheckAccount checkAccount = this.db.CheckAccounts.Where(acc => acc.ApplicationUserId == currentUserId).First();
return(checkAccount);
}
public CheckAccount CheckAcc(CheckAccount chkAcc)
{
db = new GDUDataConnectionsDataContext();
db.CheckAccounts.InsertOnSubmit(chkAcc);
db.SubmitChanges();
return(chkAcc);
}
public async Task <ActionResult <CheckAccount> > Update([FromBody] CheckAccount _CheckAccount)
{
CheckAccount _CheckAccountq = _CheckAccount;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_CheckAccountq = await(from c in _context.CheckAccount
.Where(q => q.CheckAccountId == _CheckAccount.CheckAccountId)
select c
).FirstOrDefaultAsync();
_context.Entry(_CheckAccountq).CurrentValues.SetValues((_CheckAccount));
//_context.CheckAccount.Update(_CheckAccountq);
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _CheckAccountq.CheckAccountId,
DocType = "CheckAccount",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_CheckAccountq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Insertar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _CheckAccountq.UsuarioCreacion,
UsuarioModificacion = _CheckAccountq.UsuarioModificacion,
UsuarioEjecucion = _CheckAccountq.UsuarioModificacion,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
// return BadRequest($"Ocurrio un error:{ex.Message}");
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_CheckAccountq)));
}
public void CreateCheckAccount(string firstName, string lastName, string userId, decimal initialBalance)
{
var accountNum = ("123MVC" + db.CheckAccounts.Count().ToString()).PadLeft(10, '0');
var checkAccount = new CheckAccount {
FirstName = firstName, LastName = lastName, AccountNumber = accountNum, Balance = initialBalance, ApplicationUserId = userId
};
this.db.CheckAccounts.Add(checkAccount);
this.db.SaveChanges();
}
public ActionResult Register(CheckAccount Checkacc)
{
if (ModelState.IsValid)
{
Checkacc.CheckPassword = encry.PasswordEncrytion(Checkacc.CheckPassword);
db.CheckAccounts.Add(Checkacc);
db.SaveChanges();
return(RedirectToAction("Login", "CheckAccount"));
}
return(View(Checkacc));
}
//hàm tạo mã xác nhận r lưu vào database
public void CreateVerificationCode()
{
Admin ad = new Admin();
ad = adminService.GetAdminByEmail(_email);
_VerificationCode = rd.VerificationCode();
CheckAccount chkAcc = new CheckAccount();
chkAcc.MaAdmin = ad.MaAdmin;
chkAcc.Code = _VerificationCode;
checkAccountService.CheckAcc(chkAcc);
}
public void TestGetContactDonorForCheck()
{
const string encryptedKey = "disCv2kF/8HlRCWeTqolok1G4imf1cNZershgmCCFDI=";
const string addr1 = "12 Scenic Dr";
const string addr2 = "Penthouse Suite";
const string city = "Honolulu";
const string state = "HI";
const string zip = "68168-1618";
const string displayName = "Vacationing Vera";
const int donorId = 123456789;
const string decrypAcct = "6015268542";
const string decryptRout = "042000314";
const string accountNumber = "P/H+3ccB0ZssORkd+YyJzA==";
const string routingNumber = "TUbiKZ/Vw1l6uyGCYIIUMg==";
var check = new CheckAccount
{
AccountNumber = accountNumber,
RoutingNumber = routingNumber
};
var contactDonor = new MpContactDonor
{
DonorId = donorId,
Details = new MpContactDetails
{
DisplayName = displayName,
Address = new MpPostalAddress()
{
Line1 = addr1,
Line2 = addr2,
City = city,
State = state,
PostalCode = zip
}
}
};
_donorService.Setup(mocked => mocked.GetContactDonorForCheckAccount(encryptedKey)).Returns(contactDonor);
_mpDonorService.Setup(mocked => mocked.DecryptCheckValue(accountNumber)).Returns(decrypAcct);
_mpDonorService.Setup(mocked => mocked.DecryptCheckValue(routingNumber)).Returns(decryptRout);
_mpDonorService.Setup(mocked => mocked.CreateHashedAccountAndRoutingNumber(decrypAcct, decryptRout)).Returns(encryptedKey);
var result = _fixture.GetContactDonorForCheck(accountNumber, routingNumber);
_donorService.VerifyAll();
Assert.IsNotNull(contactDonor);
Assert.AreEqual(result.DisplayName, contactDonor.Details.DisplayName);
Assert.AreEqual(result.Address, contactDonor.Details.Address);
}
/// <summary>
/// 获取验证账户(手机或邮箱)
/// </summary>
/// <returns></returns>
public ResponseModel GetVerificationAccount(UserContext userContext)
{
var result = _authCodeService.GetAuthPhoneEmailByAccId(userContext.AccId);
var checkAccount = new CheckAccount
{
Phone = result.Phone,
Email = result.Email
};
return(new ResponseModel()
{
Code = (int)ErrorCodeEnum.Success,
Data = checkAccount
});
}
public async Task <IActionResult> GetCheckAccountById(Int64 CheckAccountId)
{
CheckAccount Items = new CheckAccount();
try
{
Items = await _context.CheckAccount.Where(q => q.CheckAccountId == CheckAccountId).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public async Task <ActionResult <CheckAccount> > GetCheckAccountByCheckAccountNo([FromBody] CheckAccount _CheckAccount)
{
CheckAccount _CheckAccountq = new CheckAccount();
try
{
_CheckAccountq = _context.CheckAccount.Where(z => z.BankId == _CheckAccount.BankId &&
z.CheckAccountNo == _CheckAccount.CheckAccountNo &&
z.AssociatedAccountNumber == _CheckAccount.AssociatedAccountNumber).FirstOrDefault();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_CheckAccountq)));
}
public IHttpActionResult GetDonorForCheck([FromBody] CheckAccount checkAccount)
{
return(Authorized(token =>
{
var authResult = CheckToken(token);
if (authResult != null)
{
return (authResult);
}
var donorDetail = _checkScannerService.GetContactDonorForCheck(checkAccount.AccountNumber, checkAccount.RoutingNumber);
if (donorDetail == null)
{
return NotFound();
}
return (Ok(donorDetail));
}));
}
public async Task <ActionResult <CheckAccountLines> > Insert([FromBody] CheckAccountLines _CheckAccountLines)
{
CheckAccountLines _CheckAccountLinesq = new CheckAccountLines();
try
{
_CheckAccountLinesq = _CheckAccountLines;
Numalet let;
let = new Numalet();
let.SeparadorDecimalSalida = "Lempiras";
let.MascaraSalidaDecimal = "00/100 ";
let.ApocoparUnoParteEntera = true;
_CheckAccountLinesq.AmountWords = let.ToCustomCardinal((_CheckAccountLinesq.Ammount)).ToUpper();
_CheckAccountLinesq.IdEstado = 1;
_CheckAccountLinesq.Estado = "Activo";
//Conteo Cheques
CheckAccount chequera = await _context.CheckAccount.Where(c => c.CheckAccountId == _CheckAccountLinesq.CheckAccountId).FirstOrDefaultAsync();
chequera.NumeroActual = Convert.ToInt32(_CheckAccountLines.CheckNumber);
if (chequera.NumeroActual > Convert.ToInt32(chequera.NoFinal))
{
return(BadRequest("No se pueden emitir más Cheques."));
}
else
{
_context.CheckAccountLines.Add(_CheckAccountLinesq);
CheckAccount _CheckAccountq = await(from c in _context.CheckAccount
.Where(q => q.CheckAccountId == _CheckAccountLinesq.CheckAccountId)
select c
).FirstOrDefaultAsync();
_context.Entry(_CheckAccountq).CurrentValues.SetValues((chequera));
}
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_CheckAccountLinesq)));
}
public ActionResult CustomerLogin(CheckAccount model)
{
var Validatestr = loginservice.CustomerLoginCheck(model.CustomerID, model.CustomerPassword);
if (String.IsNullOrEmpty(Validatestr))
{
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, model.CustomerID, DateTime.Now, DateTime.Now.AddMinutes(30), false, "Customer", FormsAuthentication.FormsCookiePath);
var enTicket = FormsAuthentication.Encrypt(ticket);
Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, enTicket));
TempData["Message"] = "登入成功";
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", Validatestr);
TempData["Message"] = "帳號密碼錯誤";
return(RedirectToAction("Index", "Home"));
}
}
public async Task <IActionResult> Delete([FromBody] CheckAccount _CheckAccount)
{
CheckAccount _CheckAccountq = new CheckAccount();
try
{
_CheckAccountq = _context.CheckAccount
.Where(x => x.CheckAccountId == (Int64)_CheckAccount.CheckAccountId)
.FirstOrDefault();
_context.CheckAccount.Remove(_CheckAccountq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_CheckAccountq)));
}
private void dgvAccount_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (Globals.IsFreeVersion)
{
if (dgvAccount.Rows.Count < 1)
{
MessageBox.Show("There are no Accounts in DataBase");
return;
}
else
{
try
{
frmAccountPasswordUpdate objfrmAccountPasswordUpdate = new frmAccountPasswordUpdate();
CheckAccount objCheckAccount = new CheckAccount();
userNameForPasswordUpdate = dgvAccount.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
passwordForPasswordUpdate = dgvAccount.Rows[e.RowIndex].Cells[1].FormattedValue.ToString();
objCheckAccount.UpdatePassword(userNameForPasswordUpdate, passwordForPasswordUpdate);
objfrmAccountPasswordUpdate.Show();
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
}
}
//using (OpenFileDialog ofd = new OpenFileDialog())
//{
// ofd.Filter = "Text Files (*.txt)|*.txt";
// ofd.InitialDirectory = Application.StartupPath;
// if (ofd.ShowDialog() == DialogResult.OK)
// {
// ExportAccountsToFile(ofd.FileName);
// AddToListBox("Accounts Exported to ---" + ofd.FileName);
// }
//}
}
public void TestGetContactDonorForCheck()
{
const string encryptedAccountNumber = "P/H+3ccB0ZssORkd+YyJzA==";
const string encryptedRoutingNumber = "TUbiKZ/Vw1l6uyGCYIIUMg==";
var checkAccount = new CheckAccount
{
AccountNumber = encryptedAccountNumber,
RoutingNumber = encryptedRoutingNumber
};
var donorDetail = new EZScanDonorDetails
{
DisplayName = "Peyton Manning",
Address = new MpPostalAddress()
{
Line1 = "1 Superbowl Way",
Line2 = "Suite 1000",
City = "Denver",
State = "CO",
PostalCode = "11111-2222"
}
};
_checkScannerService.Setup(mocked => mocked.GetContactDonorForCheck(encryptedAccountNumber, encryptedRoutingNumber)).Returns(donorDetail);
var result = _fixture.GetDonorForCheck(checkAccount);
_checkScannerService.VerifyAll();
Assert.NotNull(result);
Assert.IsInstanceOf <OkNegotiatedContentResult <EZScanDonorDetails> >(result);
var okResult = (OkNegotiatedContentResult <EZScanDonorDetails>)result;
Assert.IsNotNull(okResult.Content);
Assert.AreSame(donorDetail, okResult.Content);
}
public CheckAccount CheckAcc(CheckAccount chkAcc)
{
return(checkAccIDao.CheckAcc(chkAcc));
}
public ActionResult DetailsForAdmin(int accountId)
{
CheckAccount accountDetail = this.db.CheckAccounts.Find(accountId);
return(View("Details", accountDetail));
}
// GET: CheckAccount/Details
public ActionResult Details()
{
CheckAccount userCheckAccount = this.GetUserAccount();
return(View(userCheckAccount));
}
public static void DisplayAccountRight(Literal userrights, Database db, string account, bool showdefaultrights)
{
if (account == "all")
{
userrights.Text += string.Format("<h2 id=\"{0}\">Item Rights set on all users and roles on {0} Database</h2>", db.Name);
}
else
{
userrights.Text += string.Format("<h2 id=\"{1}\">Item Rights set on account {0} on {1} Database</h2>", System.Web.HttpUtility.HtmlEncode(account), db.Name);
}
//We use a query instead of index search because, security field data is not in query, will be slower by large resultset.
var itemList = CurrentRights.GetAllRights(db);
if (itemList.Count.ToString() == Settings.GetSetting("Query.MaxItems"))
{
userrights.Text += "<p style=\"color:#FF3333;\">Alert Query limit is: " + itemList.Count + " looks like we don't have all data because this limit see Query.MaxItems in config </p>";
}
var count = 0;
var checkAccount = new CheckAccount();
string outmessage;
var defaultRights = Reporting.Shell.RightsData.RightsData.GetDefaultRights(db.Name, account, out outmessage);
if (!string.IsNullOrEmpty(outmessage))
{
userrights.Text += "<p>" + outmessage + "</p>";
}
userrights.Text += "<table id=\"table-accountrights\">";
foreach (var item in itemList)
{
var accessRules = item.Security.GetAccessRules();
if (accessRules != null)
{
if (account == "devexport")
{
userrights.Text += string.Format(",new[] {{\"{0}\",@\"{1}\"}}\n<br>", item.Paths.FullPath, item.Fields["__Security"].Value);
if (item.Paths.FullPath.StartsWith("[orphan]"))
{
userrights.Text += string.Format("orphan id={0} template={1}\n<br>", item.ID, item.TemplateID);
}
}
else
{
foreach (var rule in accessRules)
{
var defaultRight = defaultRights.FirstOrDefault(x => x.Path == item.Paths.FullPath && x.Account == rule.Account.Name && x.Right == rule.SecurityPermission.ToString() && x.Name == rule.AccessRight.Name && x.PropagationType == rule.PropagationType.ToString());
var style = "";
var message = "";
if (defaultRight != null)
{
defaultRight.Hit = true;
style = " style=\"color:#008800;\" class=\"green\"";
message = string.Format(", ({0})", defaultRight.Message);
if (!showdefaultrights)
{
continue;
}
}
var accountExsist = true;
if (rule.Account.AccountType == AccountType.Role)
{
accountExsist = checkAccount.IsRolExsisting(rule.Account.Name);
}
else
{
accountExsist = checkAccount.IsUserExsisting(rule.Account.Name);
}
if (!accountExsist)
{
message += ", Account unknown";
style = " style=\"color:#FFA500;\" class=\"orange\"";
}
if (rule.Account.Name == account)
{
userrights.Text += string.Format("<tr{3}><td>{0}</td><td>{1}</td><td>{6}</td><td>{7}</td><td>{2}{4}</td><td>{5}</td></tr>\n", item.Paths.FullPath, rule.AccessRight.Comment, rule.SecurityPermission, style, message, rule.PropagationType, rule.AccessRight.Name, RightsHelper.RightToHtml(rule));
count++;
}
else if (account == "all")
{
userrights.Text += string.Format("<tr{4}><td>{0}</td><td>{8} : {1}</td><td>{7}</td><td>{9}</td><td>{2}{5}</td><td>{3}</td><td>{6}</td></tr>\n", item.Paths.FullPath, rule.Account.Name, rule.AccessRight.Comment, rule.SecurityPermission, style, message, rule.PropagationType, rule.AccessRight.Name, rule.Account.AccountType.ToString(), RightsHelper.RightToHtml(rule));
count++;
}
else if (account == "alldevexport")
{
userrights.Text += string.Format(",new[] {{\"{0}\",\"{1}\",\"{2}\",\"{3}\"}}\n<br>", item.Paths.FullPath, rule.Account.Name.Replace("\\", "\\\\"), rule.SecurityPermission, rule.PropagationType);
count++;
}
}
}
}
}
if (count == 0)
{
if (showdefaultrights)
{
userrights.Text += "<tr><td>No rights found in this Database for the user or role.</td></tr>";
}
else
{
userrights.Text += "<tr><td>No custom rights found in this Database.</td></tr>";
}
}
userrights.Text += "</table>";
var warningRights = defaultRights.Where(x => x.Hit == false).ToList();
if (warningRights.Any())
{
userrights.Text += "<br><span style=\"color:#880000;\">WARNING:</span> Expected rights not found, or no Access:<br><table style=\"color:#880000;\">";
foreach (var warningRight in warningRights)
{
userrights.Text += string.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td></tr>\n", warningRight.Path, warningRight.Account, warningRight.Name, warningRight.Message, warningRight.Right, warningRight.PropagationType);
}
userrights.Text += "</table>";
}
}
