public Customers(object sender)
{
InitializeComponent();
this.CboDepartment.Items.Add("Business");
this.CboDepartment.Items.Add("Computing");
this.CboDepartment.Items.Add("Dentistry");
this.CboDepartment.Items.Add("Enginnering");
this.CboDepartment.Items.Add("Law");
this.CboDepartment.Items.Add("Music");
this.CboDepartment.Items.Add("Science");
this.CboDepartment.Items.Add("Yale-NUS College");
Button _button = sender as Button;
if (_button.Text != "New")
{
this.NewOrNot = false;
Customers_Load();
}
else
{
BookingSystemEntities context = new BookingSystemEntities();
Customer customer = new Customer();
var custQuery = from x in context.Customers
select x;
customer = custQuery.ToList().Last();
//string lastCustID = customer.PrimaryKey;
Customer newcustomer = new Customer();
newcustomer.ID = "A" + (Convert.ToInt32(customer.ID.Substring(1, customer.ID.Length - 1)) + 1).ToString().PadLeft(8, '0');
txtCustomerID.Enabled = false;
txtCustomerID.Text = newcustomer.ID;
this.NewOrNot = true;
}
}
private Customer SaveNew()
{
BookingSystemEntities context = new BookingSystemEntities();
Customer customer = new Customer();
customer.ID = txtCustomerID.Text;
customer.Name = txtCustomerName.Text;
customer.Department = CboDepartment.Text;
customer.Address = rtbAddress.Text;
customer.Email = txtEmail.Text;
customer.PhoneNumber = txtPhoneNo.Text;
customer.PostalCode = txtPostalCode.Text;
//BookingSystemEntities context = new BookingSystemEntities();
context.Customers.Add(customer);
context.SaveChanges();
return customer;
}