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