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