private void btnTopUp_Click(object sender, EventArgs e)
{
try
{
var q = from c in ent.Vouchers
where c.Voucher_Code.Equals(txtVCode.Text)
select c.Status;
if (q.ToList().Count == 0)
{
MessageBox.Show("Voucer code is not valid!");
}
else if (q.ToList().First().Equals("Claimed"))
{
MessageBox.Show("Voucher code is already claimed!");
}
else
{
try
{
var query = (from c in ent.Vouchers
where c.Voucher_Code.Equals(txtVCode.Text)
select c).First();
query.Status = "Claimed";
query.Claimed_By = userid;
ent.SaveChanges();
var qry = (from c in ent.Customers
where c.Customer_ID.Equals(userid)
select c).First();
Console.WriteLine(getVoucherAmount(txtVCode.Text));
Console.WriteLine(qry.Balance);
qry.Balance += getVoucherAmount(txtVCode.Text);
ent.SaveChanges();
MessageBox.Show("Voucher successfully claimed");
txtBalance.Refresh();
txtVCode.Text = getBalance(userid);
}
catch
{
MessageBox.Show("Voucher code is not valid!");
}
}
}
catch
{
MessageBox.Show("Voucher Code is already used!");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtCode.Text != code)
{
MessageBox.Show("Invalid Verification Code");
txtCode.Text = "";
this.Dispose();
Login_Form login = new Login_Form();
login.Show();
}
else
{
MessageBox.Show("Account has been verified");
BookStoreDBEntities ent = new BookStoreDBEntities();
var query = (from c in ent.Customers
where c.Email.Equals(txtEmail.Text)
select c
).First();
query.Status = "Verified";
ent.SaveChanges();
this.Dispose();
Login_Form login = new Login_Form();
login.Show();
}
}
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 btnSave_Click(object sender, EventArgs e)
{
if (txtAddress.Text == "" || txtEmail.Text == "" || txtName.Text == "" || txtPassword.Text == "" || txtPhone.Text == "" || txtUsername.Text == "")
{
MessageBox.Show("Please fill in all fields!");
}
else if (rbFemale.Checked == false && rbMale.Checked == false)
{
MessageBox.Show("Please choose your gender!");
}
else if (boxFav.SelectedIndex == -1 || boxFav.SelectedItem == "")
{
MessageBox.Show("Please choose your job!");
}
else if (txtPassword.TextLength < 6)
{
MessageBox.Show("Password must be more than 6 characters!");
}
else
{
try
{
String gender;
if (rbFemale.Checked)
{
gender = "Female";
}
else
{
gender = "Male";
}
int id = Int32.Parse(getLastID().Substring(3)) + 1;
String custid = "CST" + id.ToString().PadLeft(5, '0');
var data = new Customer
{
Customer_ID = custid,
Customer_Name = txtName.Text,
Customer_Address = txtAddress.Text,
Preffered_Genre = boxFav.Text,
Birth_Date = birthDatePicker.Value,
Phone_Number = txtPhone.Text,
Username = txtUsername.Text,
Password = txtPassword.Text,
Email = txtEmail.Text,
Gender = gender,
Status = "NOT VERIFIED",
Balance = 0
};
ent.Customers.Add(data);
VerifyCode verify = new VerifyCode();
ent.SaveChanges();
MessageBox.Show("Please verify your account to log-in");
this.Hide();
loginForm.Show();
}
catch
{
MessageBox.Show("Username or email has been used!");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (counter == 0)
{
if (txtPublisherName.Text == "" || txtPublisherName.Text == "" || txtPhoneNumber.Text == "")
{
MessageBox.Show("Please fill all data!");
}
else
{
int id = Int32.Parse(getLastPublisher().Substring(3)) + 1;
String pubid = "PBL" + id.ToString().PadLeft(4, '0');
var data = new Publisher
{
Publisher_ID = pubid,
Publisher_Name = txtPublisherName.Text,
Publisher_Address = txtPublisherAddress.Text,
Phone_Number = txtPhoneNumber.Text
};
ent.Publishers.Add(data);
ent.SaveChanges();
MessageBox.Show("Added new publisher!");
resetTextBox();
groupBoxPublisher.Enabled = false;
enableButtons();
refreshPublisherData();
fillPublisherBox();
}
}
else
{
if (txtPublisherName.Text == "" || txtPublisherName.Text == "" || txtPhoneNumber.Text == "")
{
MessageBox.Show("Please fill all data!");
}
else
{
String code = dataPublisher.CurrentRow.Cells[0].Value.ToString();
var query = (from c in ent.Publishers
where c.Publisher_ID.Equals(code)
select c).First();
query.Publisher_Name = txtPublisherName.Text;
query.Phone_Number = txtPhoneNumber.Text;
query.Publisher_Address = txtPublisherAddress.Text;
MessageBox.Show("Changes saved!");
ent.SaveChanges();
resetTextBox();
groupBoxPublisher.Enabled = false;
enableButtons();
refreshPublisherData();
fillPublisherBox();
}
}
}
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)
{
}
}
}
