public CustomerInsert(Customer s) { DataIslemleri di = new DataIslemleri(); var sql = "INSERT INTO Customer.Customer VALUES('" + s.userId + "','" + s.FName + "','" + s.LName + "','" + s.Email + "','" + s.BDay + "')"; di.ExecuteNonQuery(sql); }
public CustomerDelete(string userId) { DataIslemleri di = new DataIslemleri(); var sql = "DELETE FROM Customers WHERE CustomerID = '" + userId + "')"; di.ExecuteNonQuery(sql); }
public CustomerUpdate(string userId, Customer s) { DataIslemleri di = new DataIslemleri(); var sql = "UPDATE Customers Set [FName] ='" + s.FName + "',[LName] ='" + s.LName + "',[Email] ='" + s.Email + "',[BDay] ='" + s.BDay + "' WHERE [ID] = '" + ID + "'"; di.ExecuteNonQuery(sql); }