protected void gridKlanten_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
classes.databasemanager dm = new classes.databasemanager();
string naam = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditNaam")).Text;
string adres = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditAdres")).Text;
string telefon = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditTelefoon")).Text;
string email = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditEmail")).Text;
dm.updatecustomer(naam, adres, telefon, email);
gridKlanten.EditIndex = -1;
databind();
// lblMessage.Text = lblid.ToString() + " : Row updated";
// email moet altijd the same blijven
}
///<summary>
///<para>Creates customer if email unused</para>
///<para>Updates customer info in email known</para>
///</summary>
public bool customerupdate(string name, string adres, string telefon, string email)
{
classes.databasemanager dm = new classes.databasemanager();
bool update = false;
DataTable user = dm.getdatatablebyquery("select * from klant where email='" + email + "'");
foreach (DataRow row in user.Rows)
{
update = true;
dm.updatecustomer(name, adres, telefon, email);
}
if (update == false)
{
dm.insertcustomer(name, adres, telefon, email);
}
return(true);
}
