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) { } } }