protected void deleteButton_Click(object sender, EventArgs e) { int userName = Convert.ToInt32(personIdTextBox.Text); string passWord = this.passwordTextBox.Text; ATMDataContext db = new ATMDataContext(); if (IsvalidUser(userName, passWord)) { var deletePerson = from peoples in db.Peoples where peoples.PersonId == Convert.ToInt32(this.personIdTextBox.Text) select peoples; foreach (var person in deletePerson) { db.Peoples.DeleteOnSubmit(person); } try { db.SubmitChanges(); this.mess.Text = "Account Closed"; } catch (Exception a) { this.mess.Text = "INVALID CREDENTIALS"; Console.WriteLine(a); } } }
static ATMManager CreateATMManager() { using var dataContext = new ATMDataContext(); var users = dataContext.Users.ToList(); var accounts = dataContext.Accounts.ToList(); var history = dataContext.History.ToList(); return new ATMManager(accounts, users, history); }
public UnitOfWork(ATMDataContext dbContext, ICardRepository cardRepository, ITransactionRepository transactionRepository, IUserRepository userRepository) { _dbContext = dbContext; CardRepository = cardRepository; TransactionRepository = transactionRepository; UserRepository = userRepository; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ATMDataContext db = new ATMDataContext(); GridView1.DataSource = (from p in db.Transactions where p.PersonId == Convert.ToInt32(Session["username"].ToString()) select p).Take(10); GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ATMDataContext db = new ATMDataContext(); /* List of last three transactions*/ //GridView2.DataSource = (from p in db.Transactions select p).Take(3); GridView2.DataSource = (from p in db.Transactions where p.PersonId == Convert.ToInt32(Session["username"].ToString()) select p); GridView2.DataBind(); totalLabel.Text = string.Format("{0:C2}", total); } }
protected void submitButton_Click(object sender, EventArgs e) { ATMDataContext db = new ATMDataContext(); Transaction transact = new Transaction(); transact.PersonId = Convert.ToInt32(Session["username"].ToString()); transact.TransactionTypeId = TransactionTypeId; transact.AmountTransferred = decimal.Parse(amountTextBox.Text); transact.DateOfTransaction = DateTime.Now; db.Transactions.InsertOnSubmit(transact); db.SubmitChanges(); this.mess.Text = "Money Withdrawen! "; }
protected void submitButton_Click(object sender, EventArgs e) { ATMDataContext db = new ATMDataContext(); People person = new People(); person.FirstName = this.fNameTextBox.Text; person.LastName = this.lNameTextBox.Text; person.EmailAddress = this.emailTextBox.Text; person.Password = this.passwordTextBox.Text; person.SocialInsuranceNumber = this.socialTextBox.Text; person.DateAccountCreated = DateTime.Now; person.LastLoginDateTime = DateTime.Now; db.Peoples.InsertOnSubmit(person); db.SubmitChanges(); Response.Redirect("~/Overview.aspx"); }
private bool IsvalidUser(int userName, string passWord) { ATMDataContext db = new ATMDataContext(); var userResults = from p in db.Peoples where p.PersonId == userName && p.Password.Equals(passWord) select p; if (userResults.Any()) { return(true); } else { return(false); } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ATMDataContext dataContext, IHashProvider hashProvider) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Error"); app.UseHsts(); } AtmDbInitializar.Initialize(dataContext, hashProvider); app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseCookiePolicy(); // use cookie authentication app.UseAuthentication(); app.UseMvc(); }
protected void submitButton_Click(object sender, EventArgs e) { /* For Login element that does not work??? * int userName = Convert.ToInt32(myLogin.UserName); * string passWord = myLogin.Password; */ int userName = Convert.ToInt32(personIdTextBox.Text); string passWord = this.passwordTextBox.Text; if (IsvalidUser(userName, passWord)) { Session["username"] = personIdTextBox.Text; Session["password"] = passwordTextBox.Text; //Update last login ATMDataContext db = new ATMDataContext(); var query = from p in db.Peoples where p.PersonId == Convert.ToInt32(Session["username"].ToString()) select p; foreach (People p in query) { p.LastLoginDateTime = DateTime.Now; } try { db.SubmitChanges(); } catch (Exception z) { Console.WriteLine(z); } Response.Redirect("~/Overview.aspx"); } else { lblerror.Text = "INVALID CREDENTIALS"; } }
protected BaseRepository(ATMDataContext dbContext) { _dbContext = dbContext; dbSet = _dbContext.Set <T>(); }
public CardRepository(ATMDataContext context) : base(context) { }
public TransactionRepository(ATMDataContext context) : base(context) { }
public UserRepository(ATMDataContext context) : base(context) { }
public UserController() { _context = new ATMDataContext(); }
public TransactionController() { _context = new ATMDataContext(); }
public HomeController() { _context = new ATMDataContext(); }
public AccountController() { _context = new ATMDataContext(); }