private void btnAdd_Click(object sender, EventArgs e)
{
EnableForm(true);
customerEL = new pos.EL.Registrations.customers();
}
public bool Update(pos.EL.Registrations.customers customerEL)
{
return(customerDL.Update(customerEL));
}
public bool Delete(pos.EL.Registrations.customers customerEL)
{
return(customerDL.Delete(customerEL));
}
public long Insert(pos.EL.Registrations.customers customerEL)
{
return(customerDL.Insert(customerEL));
}
public frmSelectCustomers(frmOrders _frmOrders, pos.EL.Registrations.customers _customerEL)
{
InitializeComponent();
frmOrders = _frmOrders;
customerEL = _customerEL;
}
public bool Delete(pos.EL.Registrations.customers customerEL)
{
return(Helper.executeNonQueryBool("DELETE FROM customers WHERE customerid = '" + customerEL.Customerid + "' "));
}
public bool Update(pos.EL.Registrations.customers customerEL)
{
return(Helper.executeNonQueryBool("UPDATE customers set firstname = '" + customerEL.Firstname + "', middlename = '" + customerEL.Middlename + "', lastname = '" + customerEL.Lastname + "', contactnumber = '" + customerEL.Contactnumber + "', address = '" + customerEL.Address + "' WHERE customerid = '" + customerEL.Customerid + "' "));
}
public long Insert(pos.EL.Registrations.customers customerEL)
{
return(Helper.executeNonQueryLong("INSERT INTO customers (firstname, middlename, lastname, contactnumber, address) VALUES ('" + customerEL.Firstname + "', '" + customerEL.Middlename + "', '" + customerEL.Lastname + "', '" + customerEL.Contactnumber + "', '" + customerEL.Address + "')"));
}