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);
}