public int RegisterUser(IList<BusinessObject.User> userInfor, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.CreateUser";
var parameters = new SqlDynamicParameters();
parameters.AddAsTable("@User", userInfor);
var result = unitOfWork.Query<BusinessObject.User>(procedureName, parameters, commandType: CommandType.StoredProcedure);
return result == null? 0 : 1;
}
public int DeleteTopic(IList<int> topicId, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.DeleteTopic";
var parameters = new SqlDynamicParameters();
parameters.AddAsTable("@TopicIds", topicId);
var result = unitOfWork.Execute(procedureName, parameters, commandType: CommandType.StoredProcedure);
return result;
}
public int SaveTopic(IList<BusinessObject.Topic> topicInfo, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.SaveTopic";
var parameters = new SqlDynamicParameters();
parameters.AddAsTable("@Topic", topicInfo);
var result = unitOfWork.Query<BusinessObject.Topic>(procedureName, parameters, commandType: CommandType.StoredProcedure);
return result == null? 0 : 1;
}