/// <summary>
/// Update customer record in database.s
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btUpdateCust_Click(object sender, RoutedEventArgs e)
{
//label shows feedback of whether the record was updated successfully or not.
lbUpdated.Content = Filler.WriteCust(@"update customer set"
+ @" [firstName] = @goGetFName, [LastName] = @goGetLName, "
+ @"[DoB] = @goGetDoB, [natins] = @goGetNat, [email] = @goGetEmail, "
+ @"[allowence] = @goGetAllowence WHERE [custID] = @goGetId;",
new List <string> {
"goGetFName", "goGetLName", "goGetDoB",
"goGetNat", "goGetEmail", "goGetAllowence", "goGetId"
},
new List <object> {
txtCustFName, txtCustLname, txtDob,
txtNatins, txtEmail, txtAllowence, lbcustID
}) ? "Success" : "Fail";
}
/// <summary>
/// Add new customer
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btAddCustomer_Click(object sender, RoutedEventArgs e)
{
//validation check
if (validate() == false)
{
return;
}
//add customer to data base, if this fails then don't clear text boxes — return/exit method.
if (!filler.WriteCust(@"INSERT INTO customer ("
+ @" title, [firstName], [LastName], DoB, natins, email, allowence) VALUES ( "
+ @"@goGetTitle, @goGetFName, goGetLName, @goGetDoB, @goGetNat, @goGetEmail, "
+ @" @goGetAllowence);",
new List <string> {
"goGetTitle", "goGetFName", "goGetLName", "goGetDoB",
"goGetNat", "goGetEmail", "goGetAllowence",
},
new List <object> {
txtCustTitle, txtCustFName, txtCustLName, txtCustDoB,
txtCustNat, txtCustEmail, txtCustAllowence
}))
{
return;
}
//clear text boxes
txtCustTitle.Text = "";
txtCustFName.Text = "";
txtCustLName.Text = "";
txtCustDoB.Text = "";
txtCustEmail.Text = "";
txtCustNat.Text = "";
txtCustAllowence.Text = "";
filler?.fillDataGrid("select * from customer;");
}
