private void btnCancel_Click(object sender, EventArgs e)
{
this.Hide();
Customer_MainMenu mainmenu = new Customer_MainMenu(userid, purchasecart);
mainmenu.Show();
}
private void button1_Click(object sender, EventArgs e)
{
BookStoreDBEntities ent = new BookStoreDBEntities();
var query = from c in ent.Customers
where c.Username.Equals(txtUsername.Text) &&
c.Password.Equals(txtPassword.Text)
select c;
try
{
if (query.ToList().Count == 0)
{
MessageBox.Show("Username or password is incorrect!");
}
else
{
if (getAccountStatus() == "Verified")
{
MessageBox.Show("Login Successful");
this.Hide();
Customer_MainMenu custMain = new Customer_MainMenu(getuserID());
custMain.Show();
}
else
{
MessageBox.Show("Account has not been verified");
}
}
}
catch
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var query = (from c in ent.Customers
where c.Customer_ID.Equals(userid)
select c).First();
if (txtNewPassword.TextLength < 6)
{
MessageBox.Show("Password must be more than 6 characters");
}
else if (txtOldPassword.Text == getOldPass(userid) && txtNewPassword.TextLength >= 6)
{
query.Password = txtNewPassword.Text;
ent.SaveChanges();
this.Dispose();
Customer_MainMenu main = new Customer_MainMenu(userid, list);
main.Show();
}
else
{
MessageBox.Show("Old password is incorrect!");
}
}
private void btnCheckout_Click(object sender, EventArgs e)
{
int sum = 0;
for (int i = 0; i < dataCart.Rows.Count; ++i)
{
sum += Convert.ToInt32(dataCart.Rows[i].Cells[3].Value);
}
if (purchasecart.Count == 0)
{
MessageBox.Show("Your cart is empty!");
}
else
{
DialogResult dialogResult = MessageBox.Show("You will be charged the amount of " + sum, "Test", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (rbStoreCredit.Checked == true)
{
if (Convert.ToInt32(txtBalance.Text) > sum)
{
var data = new CustomerRequestHeader
{
Request_ID = txtRequestID.Text,
Customer_ID = userid,
Request_Date = DateTime.Now,
Payment_Type = "Store Credit",
cardnumber = null
};
ent.CustomerRequestHeaders.Add(data);
ent.SaveChanges();
for (int i = 0; i < purchasecart.Count; i++)
{
Console.WriteLine(purchasecart[i]);
Console.WriteLine(getProductID(purchasecart[i]));
var detaildata = new CustomerRequestDetail
{
Request_ID = txtRequestID.Text,
Product_ID = getProductID(purchasecart[i]),
Req_Status = "REQUESTED",
Quantity = Convert.ToInt32(dataCart.Rows[i].Cells[1].Value.ToString()),
Price = getPrice(purchasecart[i])
};
ent.CustomerRequestDetails.Add(detaildata);
ent.SaveChanges();
}
var query = (from c in ent.Customers
where c.Customer_ID.Equals(userid)
select c).First();
query.Balance = Convert.ToInt32(getCustomerBalance(userid)) - sum;
ent.SaveChanges();
MessageBox.Show("Your order will be processed soon. Thanks for your order!");
this.Hide();
Customer_MainMenu menu = new Customer_MainMenu(userid);
menu.Show();
}
else
{
MessageBox.Show("Insufficient balance!");
}
}
else
{
var data = new CustomerRequestHeader
{
Request_ID = txtRequestID.Text,
Customer_ID = userid,
Request_Date = DateTime.Now,
Payment_Type = "Credit Card",
cardnumber = txtCardNumber.Text
};
ent.CustomerRequestHeaders.Add(data);
ent.SaveChanges();
for (int i = 0; i < purchasecart.Count; i++)
{
Console.WriteLine(purchasecart[i]);
Console.WriteLine(getProductID(purchasecart[i]));
var detaildata = new CustomerRequestDetail
{
Request_ID = txtRequestID.Text,
Product_ID = getProductID(purchasecart[i]),
Req_Status = "REQUESTED",
Quantity = Convert.ToInt32(dataCart.Rows[i].Cells[1].Value.ToString()),
Price = getPrice(purchasecart[i])
};
ent.CustomerRequestDetails.Add(detaildata);
ent.SaveChanges();
}
MessageBox.Show("Your order will be processed soon. Thanks for your order!");
this.Hide();
Customer_MainMenu menu = new Customer_MainMenu(userid);
menu.Show();
}
}
else if (dialogResult == DialogResult.No)
{
}
}
}
