/// <summary> /// Updates the account information in the repository. /// </summary> /// <param name="account">Account to update.</param> /// <exception cref="StorageException"> /// It is thrown out in case of storage problems. /// </exception> public void UpdateAccount(AccountDal account) { var item = _accounts.Where(a => a.Number == account.Number).First(); _accounts.Remove(item); _accounts.Add(account); }
public int login(string username, string password) { AccountDal login = new AccountDal(); var entity = login.GetEntities(i => i.Username == username); if (entity.Count <Account>() == 0) { //Response.Write("<script>alert('不存在该用户!')</script>"); return(0); } foreach (var p in entity) { if (p.Password.Equals(password)) { //Response.Write("<script>alert('密码正确!')</script>"); //Session["key"] = TextBox1.Text; //Server.Transfer("user.aspx"); return(1); } else { //Response.Write("<script>alert('密码错误!')</script>"); return(2); } } return(0); }
public ActionResult Verify(Account account) { var AccountDal = new AccountDal(); var username = account.ID; var password = account.Password; var objUser = (from x in AccountDal.Accounts where x.ID.Equals(username) && x.Password.Equals(password) select x).ToList <Account>(); try { switch (objUser[0].Type) { case "1": return(RedirectToAction("Student", "Student", account)); case "2": return(RedirectToAction("Lecturer", "Lecturer", account)); case "3": return(RedirectToAction("Faculty", "Faculty", account)); } } catch (Exception) { } ViewBag.ErrorMessage4 = "Worng ID or Password, try again!"; return(View("Login")); }
/// <summary> /// To the BLL account. /// </summary> /// <param name="accountDal">The account DAL.</param> /// <returns>Equal BLL account.</returns> public static AccountBll ToBllAccount(this AccountDal accountDal) { AccountBll temp = FactoryAccounts.CreateAccount(accountDal.Type, accountDal.PersonId, accountDal.Number, accountDal.Balance); temp.Person = accountDal.Person.PartialMapPersonBll(); return(temp); }
/// <summary> /// To the DAL account. /// </summary> /// <param name="accountBll">The account BLL.</param> /// <returns>Equal DAL account.</returns> public static AccountDal ToDalAccount(this AccountBll accountBll) { AccountDal temp = new AccountDal(accountBll.PersoneId, accountBll.Number, accountBll.Balance, accountBll.Point, (int)accountBll.TypeId); temp.Person = accountBll.Person.PartialMapPersonDal(); return(temp); }
/// <summary> /// Deletes the specified DTO. /// </summary> /// <param name="dal">The DAL.</param> /// <exception cref="System.ArgumentException">DAL</exception> public void Delete(AccountDal dal) { if (!accounts.Contains(dal)) { throw new ArgumentException($"{nameof(dal)} doesn't contains in the storage"); } accounts.Remove(dal); }
/// <summary> /// To the DAL account. /// </summary> /// <param name="accountOrm">The account BLL.</param> /// <returns>Equal DAL account.</returns> public static AccountDal ToDalAccount(this Account accountOrm) { AccountDal temp = new AccountDal(accountOrm.PersonId, accountOrm.Number, accountOrm.Balance, accountOrm.Points, accountOrm.TypeId); temp.Person = accountOrm.Person.PartialMapPersonDal(); return(temp); }
/// <summary> /// Gets all. /// </summary> /// <returns> /// All accounts from the storage. /// </returns> public IEnumerable <AccountDal> GetAll() { foreach (Account account in context.Accounts) { AccountDal temp = account.ToDalAccount(); yield return(temp); } }
/// <summary> /// Creates the specified DTO. /// </summary> /// <param name="dal">The DTO.</param> /// <exception cref="System.ArgumentException">DAL</exception> public void Create(AccountDal dal) { if (accounts.Contains(dal)) { throw new ArgumentException($"{nameof(dal)} already exist"); } accounts.Add(dal); }
/// <summary> /// Creates the specified DTO. /// </summary> /// <param name="dal">The DTO.</param> /// <exception cref="ArgumentNullException">DAL</exception> public void Create(AccountDal dal) { if (ReferenceEquals(dal, null)) { throw new ArgumentNullException($"{nameof(dal)} is null"); } Account temp = dal.ToOrmAccount(); context.Accounts.Add(temp); }
/// <summary> /// Adds a new account to the repository. /// </summary> /// <param name="account">New account.</param> /// <exception cref="StorageException"> /// It is thrown in the event of a storage error. /// </exception> public void AddAccount(AccountDal account) { if (!_accounts.Contains(account)) { _accounts.Add(account); } else { throw new StorageException("Account already exists."); } }
/// <summary> /// A method that removes a account <paramref name="account"/> from the repository. /// </summary> /// <param name="account"> /// The Account for removal. /// </param> /// <exception cref="StorageException"> /// It is thrown out in case of storage problems. /// </exception> public void RemoveAccount(AccountDal account) { if (_accounts.Contains(account)) { _accounts.Remove(account); } else { throw new AccountNotFoundException("Account not found."); } }
/// <summary> /// To the DAL account. /// </summary> /// <param name="accountBll">The account BLL.</param> /// <returns>Equal DAL account.</returns> public static AccountDal ToDalAccount(this AccountBll accountBll) { AccountDal temp = FactoryAccounts.CreateAccount(accountBll.TypeId); temp.Valid = accountBll.Valid; temp.Number = accountBll.Number; temp.Balance = accountBll.Balance; temp.Point = accountBll.Point; temp.PersonalInfo.Id = accountBll.PersoneId; return(temp); }
/// <summary> /// Partials the map account ORM. /// </summary> /// <param name="accountDal">The account DAL.</param> /// <returns>Current ORM account.</returns> internal static Account PartialMapAccountOrm(this AccountDal accountDal) { return(new Account() { Number = accountDal.Number, Id = accountDal.Id, TypeId = accountDal.Type, Valid = accountDal.Valid, Balance = accountDal.Balance, PersonId = accountDal.PersonId, Points = accountDal.Point }); }
/// <summary> /// Gets the specified identifier. /// </summary> /// <param name="number">The number.</param> /// <returns> /// Current DTO from the storage. /// </returns> /// <exception cref="ArgumentNullException">Number.</exception> public AccountDal Get(int number) { Account temp = context.Accounts.FirstOrDefault(item => item.Number == number); if (ReferenceEquals(temp, null)) { throw new ArgumentNullException($"{nameof(number)} doesn't contains in the database"); } AccountDal result = temp.ToDalAccount(); return(result); }
/// <summary> /// Adds a new account to the repository. /// </summary> /// <param name="account">New account.</param> /// <exception cref="StorageException"> /// It is thrown in the event of a storage error. /// </exception> public void AddAccount(AccountDal account) { if (ReferenceEquals(account, null)) { throw new ArgumentNullException(nameof(account)); } using (var context = new BankAccountContext()) { context.Accounts.Add(account.ToAccountEF()); context.SaveChanges(); } }
public void TestMethod1() { AccountDal account = new AccountDal(); account.Insert(new Account { UserID = Guid.NewGuid(), Username = "******", Password = "******" }); PersonDal person = new PersonDal(); person.Insert(new Person { PID = Guid.NewGuid(), Pname = "york", Pgrade = "BoardMember", Padvs = "", Pact4fire = "", Pact4water = "", Pcontact = "", Pemail = "", Pfield_of_firm = "", Phobbies = "", Pjob4u = "", Ppro = "", Psex = "男", Ptel = "135", Ptime = 1234567, PwechatID = "", Pwork_years = 1, Username = "******" }); }
public ActionResult Verify() { if (ModelState.IsValid) { AccountDal dal = new AccountDal(); string username = Request.Form["Name"].ToString(); string userpassword = Request.Form["Password"].ToString(); List <Account> acc = (from x in dal.Users where x.userName == username && x.userPassword == userpassword select x).ToList <Account>(); AccountViewModel usr = new AccountViewModel(); bool check = false; usr.usersName = acc; if (usr.usersName.Count == 0) { Session["check"] = "opertion faild name"; return(RedirectToAction("Login")); } else { Session["check"] = "opertion"; Account login_usr = new Account(); login_usr = usr.usersName[0]; Session["Username"] = login_usr.userName; Session["Password"] = login_usr.userPassword; Session["Type"] = login_usr.userType; Session["ID"] = login_usr.userID; if (login_usr.userType == "student") { return(View("StudentHomePage", login_usr)); } if (login_usr.userType == "faculty") { return(View("FacultyHomePage", login_usr)); } if (login_usr.userType == "lecturer") { return(View("LecturerHomePage", login_usr)); } else { return(View("Login")); } } } else { return(View("Login")); } }
/// <summary> /// To the BLL account. /// </summary> /// <param name="accountDal">The account DAL.</param> /// <returns>Equal BLL account.</returns> public static AccountBll ToBllAccount(this AccountDal accountDal) { AccountBll temp = new AccountBll() { Id = accountDal.Id, Number = accountDal.Number, PersoneId = accountDal.PersonalInfo.Id, Point = accountDal.Point, TypeId = (int)accountDal.Type, Valid = accountDal.Valid, Balance = accountDal.Balance }; return(temp); }
/// <summary> /// Updates the specified DTO. /// </summary> /// <param name="dal">The DTO.</param> /// <exception cref="System.ArgumentException">DAL</exception> public void Update(AccountDal dal) { AccountDal temp = accounts.Find(item => item.Id == dal.Id); if (ReferenceEquals(temp, null)) { throw new ArgumentException($"{nameof(dal)} doesn't contains in the storage"); } temp.Balance = dal.Balance; temp.Number = dal.Number; temp.PersonId = dal.PersonId; temp.Point = dal.Point; temp.Type = dal.Type; }
public static AccountEF ToAccountEF(this AccountDal account) { return(new AccountEF { Balance = account.Balance, Bonus = account.Bonus, FirstName = account.FirstName, LastName = account.LastName, AccountType = new AccountTypeEF { Type = account.Type }, AccountId = account.Number }); }
/// <summary> /// To the BLL account. /// </summary> /// <param name="accountDal">The account DAL.</param> /// <returns>Equal ORM account.</returns> public static Account ToOrmAccount(this AccountDal accountDal) { Account temp = new Account() { Number = accountDal.Number, Id = accountDal.Id, TypeId = accountDal.Type, Valid = accountDal.Valid, Balance = accountDal.Balance, PersonId = accountDal.PersonId, Points = accountDal.Point, Person = accountDal.Person.PartialMapPersonOrm() }; return(temp); }
/// <summary> /// Updates the specified DTO. /// </summary> /// <param name="dal">The DTO.</param> /// <exception cref="ArgumentNullException">DTO is null.</exception> /// <exception cref="ArgumentException">DTO.</exception> public void Update(AccountDal dal) { if (ReferenceEquals(dal, null)) { throw new ArgumentNullException($"{nameof(dal)} is null"); } Account temp = context.Accounts.FirstOrDefault(item => item.Id == dal.Id); if (ReferenceEquals(temp, null)) { throw new ArgumentException($"{nameof(dal)} doesn't contains in the storage"); } temp = dal.ToOrmAccount(); }
public void TestMethod2() { AccountDal login = new AccountDal(); var entity = login.GetEntities(i => i.Username == "echo"); using (StreamWriter writer = new StreamWriter(@"C:\Users\lenovo\Desktop\t.txt", true)) { foreach (var p in entity) { writer.WriteLine(p.Username); } } //account.Insert(new Account { Username = "******",Password = "******" }); }
public ECService(string username) { _persondal = new PersonDal(); _ecdal = new XiaoYanDal(); _memdal = new XiaoYanDal(); _account = new AccountDal(); var resultp = _persondal.GetEntities(i => i.Username == username); foreach (var p in resultp) { _person = p; } var resulte = _ecdal.GetEntities(i => i.PID == _person.PID); foreach (var e in resulte) { _ec = e; } }
public ActionResult Verify() { AccountDal dal = new AccountDal(); string username = Request.Form["Name"].ToString(); string userpassword = Request.Form["Password"].ToString(); List <Account> acc = (from x in dal.Users where x.UserName == username && x.Password == userpassword select x).ToList <Account>(); AccountViewModel usr = new AccountViewModel(); usr.usersName = acc; if (usr.usersName.Count == 0) { TempData["Message"] = "Login has been failed, username or password does not exist"; return(RedirectToAction("Login", "Account")); } else { Account login_usr = new Account(); login_usr = usr.usersName[0]; Session["Username"] = login_usr.UserName; Session["Password"] = login_usr.Password; Session["Type"] = login_usr.type; Session["ID"] = login_usr.UserId; if (login_usr.type == "Student") { return(View("StudentHomePage", login_usr)); } if (login_usr.type == "facultyAdmin") { return(View("FacultyHomePage", login_usr)); } if (login_usr.type == "lecturer") { return(View("LecturerHomePage", login_usr)); } else { return(View("Error", login_usr)); } } }
/// <summary> /// A method that removes a account <paramref name="account"/> from the repository. /// </summary> /// <param name="account"> /// The Account for removal. /// </param> /// <exception cref="StorageException"> /// It is thrown out in case of storage problems. /// </exception> public void RemoveAccount(AccountDal account) { if (ReferenceEquals(account, null)) { throw new ArgumentNullException(nameof(account)); } using (var context = new BankAccountContext()) { var accountForRemove = FindAccount(account, context); if (ReferenceEquals(accountForRemove, null)) { throw new AccountNotFoundException(); } context.Accounts.Remove(accountForRemove); context.SaveChanges(); } }
/// <summary> /// Deletes the specified DTO. /// </summary> /// <param name="dal">The DTO.</param> /// <exception cref="ArgumentNullException">DTO.</exception> /// <exception cref="ArgumentException">DTO.</exception> public void Delete(AccountDal dal) { if (ReferenceEquals(dal, null)) { throw new ArgumentNullException($"{nameof(dal)} is null"); } Account temp = context.Accounts.FirstOrDefault(item => item.Id == dal.Id); if (ReferenceEquals(temp, null)) { throw new ArgumentException($"{nameof(dal)} doesn't contains in database"); } if (temp.Balance > 0 || temp.Balance < 0) { throw new ArgumentException($"{nameof(dal)} can't be close. Its balance doesn't equals 0"); } temp.Valid = false; }
/// <summary> /// Updates the account information in the repository. /// </summary> /// <param name="account">Account to update.</param> /// <exception cref="StorageException"> /// It is thrown out in case of storage problems. /// </exception> public void UpdateAccount(AccountDal account) { if (ReferenceEquals(account, null)) { throw new ArgumentNullException(nameof(account)); } using (var context = new BankAccountContext()) { var accountForUpdate = FindAccount(account, context); if (ReferenceEquals(accountForUpdate, null)) { throw new AccountNotFoundException(); } accountForUpdate.Balance = account.Balance; accountForUpdate.Bonus = account.Bonus; context.SaveChanges(); } }
public ActionResult MyAccountAction(AccountModel account) { AccountBal bal = new AccountBal(); bal.UserId = Convert.ToInt32(Session["loginid"]); //bal.AccountNo = account.AccountNo; //bal.IfscCode = account.IfscCode; AccountDal dal = new AccountDal(); bool status = dal.MyAccount(bal, out string IFSC, out int Acno); AccountModel model = new AccountModel(); if (status) { //bal.AccountNo = account.AccountNo; //bal.IfscCode = account.IfscCode; model.AccountNo = Acno; model.IfscCode = IFSC; model.UserId = bal.UserId; } return(View(model)); }