public void AddClient()
{
try
{
// Make new client row
NBDDataSet.CLIENTRow r = dsNBD.CLIENT.NewCLIENTRow();
r.cliName = txtName.Text.ToString();
r.cliAddress = txtAddress.Text.ToString();
if (ddlProvinces.SelectedValue != "-1")
{
r.cliProvince = ddlProvinces.SelectedValue.ToString();
}
r.cliPCode = txtPostal.Text.ToString();
r.cliPhone = txtPhone.Text.ToString();
r.cliConFName = txtFirst.Text.ToString();
r.cliConLName = txtLast.Text.ToString();
r.cliConPosition = txtPosition.Text.ToString();
// If city already exists...
if (ddlCities.SelectedValue != "-2" && ddlCities.SelectedValue != "-1")
{
r.cityID = Convert.ToInt32(ddlCities.SelectedValue.ToString());
}
// If city is new, add new row to city
else if (ddlCities.SelectedValue != "-1")
{
NBDDataSet.CITYRow city = dsNBD.CITY.NewCITYRow();
city.city = txtCities.Text.ToString();
dsNBD.CITY.Rows.Add(city);
CITYTableAdapter daCities = new CITYTableAdapter();
daCities.Update(dsNBD.CITY);
r.cityID = city.ID;
}
// Add row
dsNBD.CLIENT.Rows.Add(r);
CLIENTTableAdapter daClients = new CLIENTTableAdapter();
daClients.Update(dsNBD.CLIENT);
// Pop up alert
ScriptManager.RegisterStartupScript(this, this.GetType(),
"alert",
"alert('New Client Added!');window.location ='../Clients.aspx';",
true);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to add client: " + ex.Message;
}
}
static ClientEntry()
{
dsNBD = new NBDDataSet();
CITYTableAdapter daCities = new CITYTableAdapter();
CLIENTTableAdapter daClients = new CLIENTTableAdapter();
try
{
daCities.Fill(dsNBD.CITY);
daClients.Fill(dsNBD.CLIENT);
}
catch { }
}
