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();
}