public int Add(User user) { string query = "INSERT INTO [User] (RoleID, FirstName, LastName, EMail, Password, BirthDate, IsActive, CreatedDate) VALUES(@roleID, @name, @surname, @mail, @pass, @birthDate, @isActive, @createdDate)"; List <SqlParameter> parameters = GetParameters(user, false); _helper.AddParameters(parameters); return(_helper.ExecuteQuery(query)); }
public int Add(MyDictionary dictionary) { string query = "INSERT INTO Dictionary (Turkish, English) VALUES (@turkishWord, @englishWord)"; List <SqlParameter> parameters = GetParameters(dictionary, false); helper.AddParameters(parameters); return(helper.ExecuteQuery(query)); }
public int Add(PaymentType type) { string query = "INSERT INTO PaymentType(TypeDesc) VALUES(@typeDesc)"; List <SqlParameter> parameters = GetParameters(type); helper.AddParameters(parameters); return(helper.ExecuteQuery(query)); }
public int Add(Payment payment) { string query = "INSERT INTO Payment (TypeID, UserID, PaymentDate, Price) VALUES (@typeID,@userID, @paymentDate, @price)"; List <SqlParameter> parameters = GetParameters(payment, false); helper.AddParameters(parameters); return(helper.ExecuteQuery(query)); }
public int Add(Exercise exercise) { List<SqlParameter> listExercise = new List<SqlParameter>(); string query = "INSERT INTO Exercise(ExerciseID,ExerciseType)VALUES(@exerciseID, @exerciseType)"; listExercise.Add(new SqlParameter("exerciseID", exercise.ExerciseID)); listExercise.Add(new SqlParameter("exerciseType", exercise.ExerciseType)); helper.AddParameters(listExercise); return helper.ExecuteQuery(query); }
public int Add(UserRole role) { string query = "INSERT INTO UserRole(RoleName) VALUES('@roleName')"; helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@roleName", role.RoleName) }); return(helper.ExecuteQuery(query)); }
public int Add(Pool deadpool) { List <SqlParameter> parameters = new List <SqlParameter>(); string query = @"INSERT INTO Pool(ExerciseID,UserID,PoolName,CreatedDate,IsActive) VALUES(@exerciseID,@userID, @poolName, @createdDate, @isActive)" ; parameters.Add(new SqlParameter("@exerciseID", deadpool.ExerciseID)); parameters.Add(new SqlParameter("@userID", deadpool.UserID)); parameters.Add(new SqlParameter("@poolName", deadpool.PoolName)); parameters.Add(new SqlParameter("@createdDate", deadpool.CreatedDate)); parameters.Add(new SqlParameter("@isActive", deadpool.IsActive)); helper.AddParameters(parameters); return(helper.ExecuteQuery(query)); }