public ReservationForm(Customer cust, string flightCode, TripInfo ti)
{
reservationConn = new OleDbConnection(connString);
customer = cust;
this.ti = ti;
this.flightCode = flightCode;
drawPanel();
drawPlan();
InitializeComponent();
}
public Reservation(Customer customer, string code, string from, string to, string seat,
DateTime depart, DateTime arrive, double price)
{
this.customer = customer;
this.code = code;
this.from = from;
this.to = to;
this.seat = seat;
this.depart = depart;
this.arrive = arrive;
this.price = price;
}
public UserProfile(Customer customer)
{
profileConn = new OleDbConnection(connString);
this.customer = customer;
InitializeComponent();
id = customer.getLoginID();
txtPassword.Text = customer.getPassword();
txtName.Text = customer.getCustomerName();
txtIC.Text = customer.getIC();
txtContactNum.Text = customer.getContactNum();
customerType = customer.getCustomerType();
}
private void updateButton_Click(object sender, EventArgs e)
{
cmd.Connection = profileConn;
cmd.CommandText =
"UPDATE CustomerDetail SET [Password] = '" + txtPassword.Text +
"' ,[Name] = '" + txtName.Text +
"' ,[IC] = '" + txtIC.Text +
"' ,[contactNum] = '" + txtContactNum.Text +
"' WHERE [LoginID] = '" + id + "'";
try
{
profileConn.Open();
cmd.Parameters.AddWithValue("", txtPassword.Text);
cmd.Parameters.AddWithValue("", txtName.Text);
cmd.Parameters.AddWithValue("", txtIC.Text);
cmd.Parameters.AddWithValue("", txtContactNum.Text);
/* Update customer class */
Customer c = new Customer(id, txtPassword.Text, customerType,
txtName.Text, txtIC.Text, txtContactNum.Text);
int temp = cmd.ExecuteNonQuery();
if (temp > 0)
{
MessageBox.Show("Update Successfully!");
}
else
{
MessageBox.Show("Updata failed!");
}
profileConn.Close();
this.Hide();
MainMenu m = new MainMenu(c);
m.ShowDialog();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
profileConn.Close();
}
}
private void loginButton_Click_1(object sender, EventArgs e)
{
try
{
loginConn.Open();
string selectString =
"Select * from CustomerDetail where LoginID = '" + txtID.Text +
"' and Password = '******'";
OleDbDataAdapter da = new OleDbDataAdapter(selectString, loginConn);
OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(da);
DataTable dataTable = new DataTable();
da.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
MessageBox.Show("Welcome! " + txtID.Text);
string loginID = dataTable.Rows[0][0].ToString();
string password = dataTable.Rows[0][1].ToString();
string name = dataTable.Rows[0][2].ToString();
string ic = dataTable.Rows[0][3].ToString();
string contactNum = dataTable.Rows[0][4].ToString();
string customerType = dataTable.Rows[0][5].ToString();
Customer customer = new Customer(loginID, password, customerType, name, ic, contactNum);
this.Hide();
MainMenu mainMenu = new MainMenu(customer);
mainMenu.ShowDialog();
}
else
{
MessageBox.Show("ID or Password is incorrect! Please try again");
}
loginConn.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
loginConn.Close();
}
}
private void formCustClass(string name, string id, string contact, string memberShip)
{
if (memberShip.Equals("Member"))
theCust = new Member(name, id, contact, memberShip);
else
theCust = new Regular(name, id, contact, memberShip);
}
public Reservation(Customer customer, TripInfo tripInfo, string seat)
{
this.customer = customer;
this.tripInfo = tripInfo;
this.seat = seat;
}
public SelectTrip(Customer customer)
{
this.customer = customer;
reservationConn = new OleDbConnection(connString);
InitializeComponent();
}
public void setCust(Customer cust)
{
customer = cust;
}
public Reservation(Trips t, Customer cust, string type)
{
setTrip(t);
setCust(cust);
setTripType(type);
}
public MainMenu(Customer cust)
{
customer = cust;
InitializeComponent();
lblCustomerID.Text = "Welcome! " + customer.getLoginID();
}
