コード例 #1
0
        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);
        }
コード例 #2
0
        public CustomerDelete(string userId)
        {
            DataIslemleri di  = new DataIslemleri();
            var           sql = "DELETE FROM Customers WHERE CustomerID = '" + userId + "')";

            di.ExecuteNonQuery(sql);
        }
コード例 #3
0
        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);
        }